Maker

Mauro Pellonara • Peerlist

✈️ What is PlaneCrashData?PlaneCrashData is an open aviation safety intelligence platform that visualizes over a century of flight incident history (1919–Present) and provides instant safety score lookups for any commercial flight in the world.💡 Why I Built ItAviation incident data has historically been gatekept by antiquated 90s-era government websites or paywalled enterprise APIs. As both an engineer and traveler, I wanted to build a modern, high-performance platform that gives passengers and avgeeks instant clarity without sensationalism. 🏗️ Technical Architecture &amp; Stack Deep-Dive- Frontend &amp; Framework: [Nuxt 4](<a target="_blank" rel="noopener noreferrer nofollow ugc" class="break-all link-break text-gray-500 hover:underline" href="https://nuxt.com/">https://nuxt.com/</a>) (Vue 3, TypeScript) + Nuxt UI + Tailwind CSS. Fully reactive SSR application with zero-layout-shift client hydration.- Edge Backend &amp; Database: Cloudflare Workers + [Cloudflare D1](<a target="_blank" rel="noopener noreferrer nofollow ugc" class="break-all link-break text-gray-500 hover:underline" href="https://developers.cloudflare.com/d1/">https://developers.cloudflare.com/d1/</a>) (Serverless SQLite at the Edge) with Drizzle ORM. Delivers global sub-50ms query response times at ~$5/month operating cost.- Automated Data Ingestion: Automated Nitro scheduled cron tasks run every 2 hours to fetch, sanitize, normalize, and backfill verified incidents from ASN, NTSB, and international aviation registries.- 3D Geospatial Engine: `<a target="_blank" rel="noopener noreferrer nofollow ugc" class="break-all link-break text-gray-500 hover:underline" href="http://globe.gl">globe.gl</a>` + Three.js / WebGL with custom shader pins, altitude arcs, and temporal scrubbing across 100+ years of geo-located crash data.- Mobile Apps: Built with [Capacitor](<a target="_blank" rel="noopener noreferrer nofollow ugc" class="break-all link-break text-gray-500 hover:underline" href="https://capacitorjs.com/">https://capacitorjs.com/</a>) for native distribution across iOS and Android with offline caching and native share sheets. ✨ Core Capabilities1. 🔍 Check My Flight: Historical safety score calculation for any commercial flight number &amp; aircraft model (Boeing 737, Airbus A320, A350, 787, etc.).2. 🌍 3D Incident Globe: Interactive temporal scrubbing across 100+ years of aviation safety milestones with multi-filter queries (airline, manufacturer, severity).3. 📊 Airline Safety Index: Objective incident-free passenger kilometer benchmarks and fleet safety metrics.4. 🚨 Live Safety Ingestion: Synchronized reports every 2 hours from official safety investigation bureaus. 🛠️ Challenges &amp; Learnings- Rendering 10,000+ Geospatial Points in WebGL: Optimized data payloads by clustering coordinates and streaming incident data on-demand during temporal scrubbing.- Edge Database Optimization with D1: Structured SQLite indexes for fast compound lookups on `(carrier_code, flight_number)` and `(manufacturer, model)`.Check out the live platform at <a target="_blank" rel="noopener noreferrer nofollow ugc" class="break-all link-break text-gray-500 hover:underline" href="https://www.planecrashdata.com/**">https://www.planecrashdata.com/</a> — I'd love feedback from fellow engineers on the edge query architecture and WebGL performance!

PlaneCrashData

<h3>Stop the Slop: AI Script Detector for YouTube</h3><ul><li>Real-time AI Detection: Analyzes YouTube video transcripts in real-time to identify AI-generated content, robotic narration, and recycled scripts.</li><li>Privacy-First: A free, open-source browser extension with zero tracking, no login required, and no tracking cookies. Video transcripts are processed locally for analysis.</li><li>Intuitive Interface: Features AI probability gauges and sentence-by-sentence linguistic heatmaps displayed directly on the YouTube page.</li><li>Thumbnail &amp; Feed Badges: Receive instant AI probability badges on video thumbnails in your Home feed, Search, and Recommendations.</li><li>Sentence-Level Heatmap: Inspect a detailed breakdown to pinpoint specific robotic sentences and repetitive formulas that triggered the AI detector.</li><li>Performance Optimized: Utilizes Cloudflare Edge Caching for sub-100ms instant verdicts on analyzed videos.</li><li>Adaptive Design: Seamlessly matches YouTube's dark and light aesthetics with automatic OS system preference detection.</li><li>Multi-Browser Compatibility: Built on modern Manifest V3 standards, compatible with Google Chrome, Brave, Microsoft Edge, Opera, and Mozilla Firefox.</li></ul>How it Works:<ol><li>Extract Transcript: The extension non-intrusively extracts official or auto-generated subtitle tracks directly from the YouTube page.</li><li>Edge AI Evaluation: The transcript is analyzed via a fast Cloudflare Worker API to detect typical LLM stylistic markers, sentence perplexity, and repetitive filler formulas.</li><li>Instant In-Page Score: Receive an intuitive probability gauge and an itemized breakdown of flagged sentences in the extension popup and on-screen badge.</li></ol>Stop the Slop is 100% free, open-source under the MIT license, and contains no ads or paywalls. It requires a transcript to analyze and works with both manual creator subtitles and YouTube's auto-generated captions.

Stop the Slop

- Built a user-friendly web app that helps private tutors organize their lessons, manage their business and improve the learning experience - Provide tutors with insights into their business performance by displaying the data collected within the app in various graphs

Tutario - Assistant for Private Tutors

PlaneCrashData - Aviation Accident Tracker

- A video game adaptation written in Java of the famous board game Carcassonne - Follows all the Object Oriented Programming principles and uses Hibernate as ORM - Received a perfect score of 30/30 in both Object Oriented Programming and Databases university exams

Caesena

- Developed a model that determines whether or not certain mushrooms are toxic based on specific measurements - Compared performance between Random Forest, KNN and Logistic Regression models - Received a perfect score of 30/30 in the Data Science university exam

Mushroom Toxicity Classification

- A TikTok-like social network written in PHP focused on cooking and sharing recipes - Fully compliant to the WCAG 2.0 AA standard, allowing users with disabilities to use the social network without limitations - Received a perfect score of 30/30 with honours in the Web Development university exam

Gnam.My

- An ASP.NET Core MVC C# web app for a sustainable online marketplace. - Can be deployed using Docker containers and also includes a Rest API. - Placed 7th in the Samsung LetsApp Solve for Tomorrow competition with 500+ contestants.