NTSB investigations, 2019, FL
13 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 11 |
| 2012 | 6 |
| 2013 | 6 |
| 2014 | 13 |
| 2015 | 9 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 9 |
| 2019 | 13 |
| 2020 | 6 |
| 2021 | 6 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 4 |
| 2025 | 5 |
| 2026 | 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 year(c.\"eventDate\") = 2019
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2019 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.NTSB GAA20CA044Accident · No injuriesData collectionFinal reportRichard B Carpenter AR-1 · Brooksville, FLThe pilot's failure to attain the proper rotor speed before takeoff, which resulted in the rotor blade striking the rudder. Contributing to the accident was the pilot's failure to abort the takeoff in a timely manner.NTSB ERA19LA282Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 337 · St. Augustine, FLThe failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.NTSB ERA19CA291Accident · No injuriesData collectionFinal reportBeech 55 · Sebring, FLThe passenger’s inadvertent retraction of the landing gear during the landing roll without being instructed to do so by the pilot.NTSB GAA19CA585Accident · No injuriesData collectionFinal reportBeech 23 · Keystone Heights, FLThe pilot's failure to maintain clearance from a construction sign during taxi operations.NTSB GAA19CA505Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Oxford, FLThe pilot’s continued use of battery power during a nonpowered flight in a powered-glider, which depleted the battery to a level that was insufficient to power the starter during the engine restart sequence and resulted in a forced landing to a soft field and…NTSB ERA19LA255Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Tampa, FLThe failure of the right main landing gear to fully extend and lock for reasons that could not be determined.NTSB GAA19CA488Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper decision to turn off the runway while the airplane was moving too fast after landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA19CA466Accident · No injuriesData collectionFinal reportDiamond DA 42 NG · Palatka, FLThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended due to distraction, which resulted in a gear-up landing.NTSB ERA19LA206Accident · No injuriesClass 3 · LimitedFinal reportBell OH58C · Gainesville, FLThe flight instructor's failure to maintain control of the helicopter during a simulated forced landing autorotation, which resulted in pylon whirl that substantially damaged the helicopter.NTSB ERA19TA146Accident · No injuriesClass 3Final reportCessna 172 · Fort Myers, FLThe pilot's failure to remain clear of a light pole while taxiing.NTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.NTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.