NTSB investigations, 2009
199 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 150 |
|---|---|
| 2009 | 199 |
| 2010 | 195 |
| 2011 | 156 |
| 2012 | 171 |
| 2013 | 128 |
| 2014 | 150 |
| 2015 | 163 |
| 2016 | 137 |
| 2017 | 135 |
| 2018 | 143 |
| 2019 | 118 |
| 2020 | 86 |
| 2021 | 98 |
| 2022 | 76 |
| 2023 | 68 |
| 2024 | 37 |
| 2025 | 29 |
| 2026 | 9 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.NTSB ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.NTSB ERA10RA097Accident · 2 fatalForeign investigationDassault/Sud Falcon 20 · Matthew Town, BahamasOn December 17, 2009, about 1922 eastern standard time, a Dassault Falcon 20, N28RK, crashed in a remote area approximately 12 miles east of Matthew Town, Inagua, Bahamas. The 2 pilots were killed and the airplane was destroyed. Night, visual meteorological…NTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.NTSB ERA10FAMS1Accident · 1 fatalMissing aircraftFinal reportCirrus SR22 · Gulf of MexicoUndetermined (airplane and pilot missing).NTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…NTSB WPR10LA076Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Lehi, UTThe loss of engine power during cruise flight for undetermined reasons.NTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.NTSB CEN10WA066Accident · 3 fatalForeign investigationBeech F90 · Egelsbach, GermanyUnder the jurisdiction and control of the German government.NTSB CEN10FA063Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Harrison, MIA loss of aircraft control for undetermined reasons.NTSB ERA10LA086Accident · 2 fatalLimited investigationFinal reportCox Busby Mustang · Plant City, FLThe pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.NTSB ERA10LA084Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Hillsboro Beach, FLA total loss of engine power for undetermined reasons.NTSB CEN10LA064Accident · Serious injuriesLimited investigationFinal reportKrusmark David Homer Searey · St. Paul, MNThe pilot's delay in aborting the takeoff during the takeoff roll when he became aware of the engine not producing full power.NTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.NTSB WPR10WA070Accident · 4 fatalForeign investigationRobinson R44 · Netanya, Israel, IsraelThe accident is under the jurisdiction of, and is being investigated, by the State of Israel, Ministry of Transport, Aviation Incidents and Accidents Investigation (AIAI).NTSB CEN10CA060Accident · No injuriesData collectionFinal reportBoeing B75N1 · St. Louis, MOA loss of engine power for undetermined reasons.NTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.NTSB WPR10LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZA loss of engine power for undetermined reasons.NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.NTSB ERA10LA050Accident · Minor injuriesLimited investigationFinal reportGrumman Aircraft ENG G-111 · Ft Pierce, FLA total loss of left engine power and subsequent failure of the airplane to maintain airspeed and altitude on the remaining engine for undetermined reasons.NTSB CEN10LA039Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Brenham, TXThe loss of engine power (right engine) during initial climb for undetermined reasons.NTSB CEN10FA029Accident · 1 fatalField investigationFinal reportBeech A36TC · Kalamazoo, MIThe loss of engine power for an undetermined reason.NTSB WPR10CA084Accident · No injuriesData collectionFinal reportGolden Circle Tierra I · Jensen, UTA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.NTSB WPR10FA029Accident · No injuriesField investigationFinal reportAgusta A119 · Blythe, CAThe loss of engine power during cruise flight for undetermined reasons.NTSB ERA10WA044Accident · 1 fatalForeign investigationBritten Norman BN2A · Kralendijk, Bonaire, NTOn October 22, 2009, about 1417 universal coordinated time, a Britten Norman BN-2A/26, PJ-SUN, experienced a right engine failure during cruise flight, and subsequently ditched in the Caribbean Sea, near Kralendijk, Bonaire, Netherlands Antilles. The airplane…NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.NTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.NTSB CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.NTSB WPR10LA021Accident · Serious injuriesLimited investigationFinal reportAerotrike Naked Cobra · Virgin, UTA loss of engine power during cruise flight for undetermined reasons.NTSB ERA10LA019Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · La Belle, FLThe loss of main rotor rpm due to the failure of one or more of the drive belts for undetermined reasons.NTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.NTSB ERA10LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Marathon, FLA total loss of engine power for undetermined reasons.NTSB CEN10LA008Accident · Minor injuriesLimited investigationFinal reportCrawford Alan R Glasair II · San Saba, TXA partial loss of engine power for undetermined reasons.NTSB ERA10CA001Accident · No injuriesData collectionFinal reportBell 47D1 · Dorrance, PAA total loss of engine power due to fuel exhaustion for undetermined reasons.NTSB CEN10WA003Accident · 1 fatalForeign investigationCessna F172N · Sulzberg, GermanyUnder the jurisdiction and control of the German government.NTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB ANC09LA110Accident · No injuriesLimited investigationFinal reportHughes 369A (OH-6A) · Palmer, AKA partial loss of engine power after take off for an undetermined reason, which resulted in a hard landing.NTSB WPR09LA471Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A+ · Myrtle Creek, ORA partial loss of engine power during takeoff for undetermined reasons.NTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.NTSB ANC09CA106Accident · Serious injuriesData collectionFinal reportRittal Alfred Timothy Glastar · Tuluksak, AKA loss of control for an undetermined reason during the takeoff portion of an aborted landing at an off-airport site, resulting in a collision with terrain.NTSB CEN09IA595Incident · No injuriesIncident investigationFinal reportBeech V35 · Nacogdoches, TXThe complete loss of engine power due to failure of the number two connecting rod. The reason for the connecting rod failure could not be determined.NTSB CEN09LA594Accident · No injuriesLimited investigationFinal reportMcclish Funk B85C · Coffeyville, KSAn in-flight fire for undetermined reasons.NTSB WPR09LA452Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Paula, CAA total loss of engine power during takeoff for undetermined reasons.NTSB ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.NTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.NTSB CEN09CA584Accident · Minor injuriesData collectionFinal reportYates W/Lazar M Safari Helicopter · Cedar Park, TXAn in-flight separation of the tail rotor blades and the tail rotor gearbox for undetermined reasons.NTSB CEN09WA582Accident · 2 fatalForeign investigationReims F172 · Commune de Brethencourt, FranceUnder the jurisdiction and control of the French government.NTSB ERA09LA509Accident · Serious injuriesLimited investigationFinal reportHebert Kitfox Speedster · Morrisville, VTA total loss of engine power during the initial climb after takeoff for undetermined reasons.