NTSB investigations, 2009
15 cases where NTSB found Development.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 15 |
| 2010 | 18 |
| 2011 | 14 |
| 2012 | 11 |
| 2013 | 9 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 5 |
| 2019 | 5 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 6 |
| 2023 | 9 |
| 2024 | 11 |
| 2025 | 2 |
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\") = 2009
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0401'))
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", '0401')) 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 CEN10LA050Accident · 1 fatalLimited investigationFinal reportAugustine David L Sonex · Burnet, TXThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall. Contributing to the accident was the loss of engine power due to a clogged fuel screen that resulted in fuel starvation caused by the builder's inappropriate use of a fuel…NTSB ERA09LA540Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Gettysburg, PAThe failure of the left main wheel attachment fitting due to overstress.NTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…NTSB CEN09IA481Incident · No injuriesIncident investigationFinal reportRaytheon BE-400A · Sugar Land, TXThe failure of the spinner following an unavoidable bird strike. Contributing to the incident were the inadequate engine bird strike certification requirements in place at the time the engine was certified.NTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.NTSB CEN09LA341Accident · Minor injuriesLimited investigationFinal reportHuston Charles D Pitts S-12 · Spicewood, TXA total loss of engine power due to fuel starvation as a result of the presence of an unidentified contaminant in the fuel system which clogged the fuel flow sensor. Contributing to the accident was the manufacturer’s installation of the fuel flow sensor…NTSB ERA09FA304Accident · No injuriesField investigationFinal reportBeech C90A · Yeehaw Junction, FLThe failure of the flightcrew to recognize that both engines were being supplied fuel only from the right wing fuel tanks resulting in loss of power in both engine due to fuel starvation. Contributing to the accident were the inoperative the left auxiliary…NTSB WPR09LA253Accident · 2 fatalLimited investigationFinal reportGauchat Safari · Rock Springs, AZThe separation of the main rotor head during cruise flight as a result of cyclic fatigue of the main rotor head spindle. The fatigue crack was due to an inadequate manufacturing process.NTSB ANC09GA040Accident · No injuriesFinal reportRobinson Helicopter R44 · Iliamna, AKThe main rotor transmission mount design, which resulted in an in-flight vibration/oscillation, and damage to the helicopter during an emergency descent and hard landing. Contributing to the accident was the lack of information from the manufacturer regarding…NTSB WPR09FA234Accident · 2 fatalField investigationFinal reportUpton Bakeng Duce · Ramona, CAAn in-flight separation of the right wing, which resulted from the pilot's performance of a maneuver that produced aerodynamic loads that exceeded the wing spar’s degraded strength. The wing spar strength degradation was due to the builder's failure to comply…NTSB CEN09LA145Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Wichita, KSThe failure of line personnel to ensure that the airplane was serviced with the proper fuel. Contributing to the accident was the Federal Aviation Administration's approval of a Supplemental Type Certificate (STC) which allowed an improper fuel filler…NTSB DCA09MA026Accident · Serious injuriesClass 1 · MajorFinal reportAirbus A320 · Weehawken, NJThe ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…NTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.NTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…NTSB ENG09IA002Incident · No injuriesIncident investigationFinal reportBoeing 777 · Atlanta, GAThe fan blade fractured due to a fatigue crack that was the result of the combination of the breakdown of the fan blade lubrication system and residual fatigue life usage following the last overhaul of the fan blade. Contributing to the fracture was the…