NTSB investigations, 2009
32 cases where the sequence of events included Preflight or dispatch event.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 32 |
| 2010 | 29 |
| 2011 | 28 |
| 2012 | 19 |
| 2013 | 28 |
| 2014 | 25 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 25 |
| 2018 | 16 |
| 2019 | 7 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 7 |
| 2023 | 14 |
| 2024 | 3 |
| 2025 | 10 |
| 2026 | 6 |
Where
Open the mapLatest 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\") = 2009
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '030' 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") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' 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 WPR10LA075Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Temple Bar, AZThe pilot’s inadequate preflight inspection. Contributing to the accident was the pilot’s diverted attention during the preflight inspection.NTSB ERA10FA062Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Dennisville, NJThe non-instrument-rated pilot's decision to depart into known instrument meteorological conditions, which resulted in his spatial disorientation and overcontrol of the airplane and the subsequent in-flight structural failure. Contributing to the accident was…NTSB ERA10LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Fairview, NCA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB WPR10FA027Accident · 1 fatalField investigationFinal reportCessna T210G · Provo, UTA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight inspection.NTSB CEN10FA007Accident · Serious injuriesField investigationFinal reportBeech 100 · Aurora, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.NTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.NTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.NTSB ERA09CA485Accident · No injuriesData collectionFinal reportBell 206L-3 · White Plains, NYThe pilot's failure to disconnect the ground power unit prior to takeoff.NTSB WPR09LA396Accident · Minor injuriesLimited investigationFinal reportBeech A60 · Minidoka, IDA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA09LA459Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sussex, NJThe pilot’s improper pre-flight planning and take off over gross weight limits.NTSB ERA09LA453Accident · Serious injuriesLimited investigationFinal reportLaurienzo Gabriel A Varieze · North Augusta, SCA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection.NTSB CEN09CA477Accident · No injuriesData collectionFinal reportCessna A185F · River Falls, WIThe pilot not checking the security of the fuel caps prior to flight leading to fuel exhaustion and the subsequent non-mechanical loss of engine power during descent.NTSB ERA09LA392Accident · 1 fatalLimited investigationFinal reportNoles Vance L Vans RV7A · Sanderson, FLThe pilot's continued visual flight into instrument meteorological conditions with convective activity and thunderstorms. Contributing to the accident was his failure to get an adequate weather briefing.NTSB CEN09CA342Accident · No injuriesData collectionFinal reportBeech S35 · Decatur, TXBoth pilots' inadequate preflight inspection and failure to identify the presence of dirt and insect larvae in the pitot tube, and the owner-pilot's attempt to turn off the runway and onto the taxiway at an excessive speed during the aborted takeoff.NTSB CEN09LA330Accident · Serious injuriesLimited investigationFinal reportFrey FLY Baby · Keller, TXA partial loss of engine power due to an obstruction of the air intake, as reported by the pilot. Contributing to the accident was the pilot's insufficient preflight inspection.NTSB ERA09CA297Accident · No injuriesData collectionFinal reportCessna 172 · Perryville, MDA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.NTSB WPR09LA218Accident · No injuriesLimited investigationFinal reportWeinberg RV-6 · Sparks, NVThe pilot's failure to follow the pre-takeoff checklist that resulted in the canopy opening during takeoff, which created a distraction, and his failure to maintain aircraft control during landing.NTSB CEN09CA269Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Adrian, MIThe flight instructor's inadequate compensation for the strong, gusting crosswind during landing. Contributing to the accident was the flight instructor's decision to attempt flight with known adverse weather approaching the airport.NTSB CEN09CA245Accident · No injuriesData collectionFinal reportCessna R182 · Granger, TXA loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.NTSB WPR09LA156Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Wendover, UTA loss of engine power due to fuel exhaustion, which resulted from an inadequate preflight inspection by both pilots and their failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the flight instructor's…NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB WPR09LA108Accident · No injuriesLimited investigationFinal reportDouglas DC-3/65AR · Mojave, CAThe student pilot failed to follow the checklist and set the takeoff trim properly prior to takeoff resulting in a loss of directional control. Contributing to the accident were the certified flight instructor's inadequate supervision and delayed remedial…NTSB ERA09FA141Accident · 1 fatalField investigationFinal reportRemos Remos GX · Sebring, FLThe pilot's inadequate preflight assembly and inspection which resulted in the pushrod connection to the left aileron not being connected, which led to a subsequent inflight loss of control and impact with terrain.NTSB WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.NTSB WPR09LA071Accident · Minor injuriesLimited investigationFinal reportPZL PZL-104 35A · Oakland, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.