NTSB investigations, FL
7 cases where NTSB found Passenger/crew doors.
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2020 | 1 |
| 2024 | 1 |
Where
Latest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01035210'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035210')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA24FA154Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · St. Augustine, FLThe pilot’s failure to maintain adequate airspeed of the airplane while in the traffic pattern, which resulted in an aerodynamic stall/spin. Contributing was the pilot’s distraction due to the in-flight opening of the main cabin door, which resulted from the…NTSB ERA20CA303Accident · No injuriesClass 4 · Data collectionFinal reportZenith CH601 · Punta Gorda, FLAn inadvertent opening of the airplane’s canopy on takeoff, which resulted in a loss of control and runway excursion.NTSB ERA15LA130Accident · Serious injuriesLimited investigationFinal reportRobertson James F Velocity STD/RG E · Sebastian, FLThe pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…NTSB ERA15LA087Accident · No injuriesLimited investigationFinal reportMDS Fying Zenith Zodiac CH 650 · Fort Pierce, FLThe inadequate modification of the airplane’s canopy latching mechanism, which resulted in the inadvertent opening of the canopy while on final approach to land and a subsequent loss of pitch control.NTSB ERA14LA180Accident · Serious injuriesLimited investigationFinal reportHelpling Helen C Tango 2 · Ocala, FLThe pilot's failure to maintain airplane control after the left cockpit canopy opened during takeoff for reasons that could not be determined due to fire damage.NTSB ERA12LA356Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B16 · Hallandale, FLThe failure of the co-pilot to properly close and latch the passenger door before departure, and the flight crew's failure to ensure that the door was secure by using the door warning system. Contributing to the accident was the flight crew's inadequate use…NTSB MIA08LA089Accident · 1 fatalLimited investigationFinal reportDayon Lancair Legacy · Lakeland, FLThe pilot's failure to maintain aircraft control. Contributing to the accident was the pilot's distraction with the canopy during takeoff.