NTSB investigations, 2008, FL
12 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 28 |
| 2010 | 19 |
| 2011 | 22 |
| 2012 | 25 |
| 2013 | 22 |
| 2014 | 22 |
| 2015 | 21 |
| 2016 | 21 |
| 2017 | 17 |
| 2018 | 18 |
| 2019 | 19 |
| 2020 | 8 |
| 2021 | 16 |
| 2022 | 16 |
| 2023 | 8 |
| 2024 | 20 |
| 2025 | 18 |
| 2026 | 3 |
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\") = 2008
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\" = '440' 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") = 2008 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" = '440' 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 ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB ERA09LA081Accident · No injuriesLimited investigationFinal reportMerrell Stephen F1 Rocket · Sebastian, FLA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB ERA09CA097Accident · Serious injuriesData collectionFinal reportMiller Long EZ/XP · Wauchula, FLA total loss of engine power for undetermined reasons.NTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.NTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.NTSB NYC08CA297Accident · No injuriesData collectionFinal reportErcoupe 415-C · Sebring, FLA bird strike which substantially damaged the propeller and required the engine to be secured. Contributing to the accident was the damaged propeller.NTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…NTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.NTSB CHI08LA104Accident · No injuriesLimited investigationFinal reportVic Tatelman Baby Belle · Lakeland, FLThe failure of the tailrotor driveshaft hanger bearing and jamming of the tailrotor.NTSB NYC08LA106Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Pahokee, FLThe pilot's decision to depart with a known deficiency with the engine, which resulted in a loss of engine power. Contributing to the accident was the loss of engine power due to the failure of the engine-driven fuel pump.NTSB MIA08LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Kissimmee, FLThe probable cause of this accident is undetermined.NTSB NYC08LA077Accident · No injuriesLimited investigationFinal reportBell 407 · DeLand, FLA total loss of engine power due to the fatigue failure of a third stage turbine wheel blade.