NTSB investigations, 2009
222 cases where NTSB found Aircraft systems.
Cases per year
| 2008 | 286 |
|---|---|
| 2009 | 222 |
| 2010 | 215 |
| 2011 | 232 |
| 2012 | 239 |
| 2013 | 198 |
| 2014 | 174 |
| 2015 | 178 |
| 2016 | 195 |
| 2017 | 193 |
| 2018 | 203 |
| 2019 | 196 |
| 2020 | 163 |
| 2021 | 181 |
| 2022 | 171 |
| 2023 | 200 |
| 2024 | 200 |
| 2025 | 133 |
| 2026 | 54 |
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\", '0102'))
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", '0102')) 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 ANC10LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot’s failure to ensure that the airplane’s fuel selector valve was on before takeoff, resulting in a loss of engine power due to fuel starvation, and his subsequent decision to attempt a low altitude turn towards the departure airport, resulting in an…NTSB CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.NTSB CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.NTSB ENG10RA017Incident · No injuriesForeign investigationBombardier DHC-8 · London, United KingdomOn 12/21/2009 a Bombardier DHC-8-402 (G-JEDI) suffered a loss of AC electrical power on departure from London Gatwick Airport. The crew returned to London Gatwick for an uneventful landing. Subsequent maintenance revealed heat damage to a wiring loom in the…NTSB WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.NTSB CEN10LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · St. Louis, MOThe pilot's failure to properly follow the manual landing gear extension procedure, resulting in a gear-up landing.NTSB ERA10IA095Incident · No injuriesIncident investigationFinal reportBeech 58 · Lexington, KYThe overstress failure of the nose landing gear aft drag brace.NTSB ERA10LA107Accident · No injuriesLimited investigationFinal reportMaule M5 · LaGrange, GAThe failure of the right main landing gear for undetermined reasons.NTSB CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.NTSB CEN10CA067Accident · No injuriesData collectionFinal reportCessna 182 · Carmi, ILA total loss of engine power due to fuel starvation as a result of the pilot's failure to assure that the fuel tank filler cap was secured prior to flight.NTSB WPR10CA061Accident · Minor injuriesData collectionFinal reportBoeing A75N1 · Deer Valley, AZThe pilot's failure to maintain directional control.NTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.NTSB CEN10LA052Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Saginaw, TXThe pilot's inability to maintain control of the airplane due to a pinched trim system wire that resulted in a runaway nose-down pitch trim.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 ERA10CA049Accident · Minor injuriesData collectionFinal reportErcoupe 415 · Germantown, NYThe pilot's decision to continue operation of the airplane with a known mechanical deficiency.NTSB WPR10CA041Accident · No injuriesData collectionFinal reportCessna 180 · Bountiful, UTThe failure of the inner tube of the right main tire during the landing roll.NTSB WPR10LA039Accident · Minor injuriesLimited investigationFinal reportSauer KR-2S · Glendale, AZA loss of engine power due to fuel starvation as a result of a reduced fuel flow to the engine resulting from a misrouted fuel tank vent line, during initial climb.NTSB ERA10LA042Accident · No injuriesLimited investigationFinal reportBeriev BE-103 · Miami, FLA malfunction of the landing gear retraction/extension and indication system for undetermined reasons, which resulted in one or more components being improperly positioned for the water landing.NTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.NTSB CEN10IA030Incident · No injuriesIncident investigationFinal reportCurtiss Wright P-40E · Lincoln, NEThe right landing gear's partial retraction during landing due to paint contamination of the landing gear handle detent.NTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB WPR10LA034Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Cedar City, UTThe failure of the landing gear accumulator/regulator and the installation of the improper priority valve, which precluded the landing gear from extending and locking into place.NTSB CEN10LA014Accident · No injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe mechanic's failure to find and repair a leaking main landing gear hydraulic line during an annual inspection.NTSB WPR10LA014Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Franklin, CAA total loss of engine power due to fuel starvation, as a result of the certified flight instructor's improper fuel system management.NTSB WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…NTSB WPR10CA011Accident · No injuriesData collectionFinal reportCessna 180 · Pistol Creek, IDThe separation of one of the airplane's main landing gear legs during landing in variable gusting wind conditions, due to the nut being stripped from the attachment bolt.NTSB ERA10LA005Accident · No injuriesLimited investigationFinal reportCessna 210 · Louisville, KYA malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.NTSB WPR10LA004Accident · No injuriesLimited investigationFinal reportCessna 172A · Payson, AZThe stress corrosion cracking of the nose gear landing fork, which resulted in the fork's failure during landing.NTSB ERA10LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Whiteville, NCThe pilot's improper flare and subsequent hard landing during an intentional gear-up landing following multiple mechanical malfunctions. Also causal to the accident was an inoperative landing gear emergency-down valve which had blockage for undetermined…NTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.NTSB WPR09CA468Accident · No injuriesData collectionFinal reportCessna 195 · Kingman, AZFailure of the right landing gear wheel attachment bolts.NTSB WPR09CA467Accident · No injuriesData collectionFinal reportBeech 35-C33 · Tillamook, ORA 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. Contributing to the accident was a malfunctioning fuel gage.NTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.NTSB ERA09CA541Accident · No injuriesData collectionFinal reportCessna 172P · Pensacola, FLThe pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.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 CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.NTSB ERA09LA532Accident · No injuriesLimited investigationFinal reportRyan Navion · Fire Island, NYA total loss of engine power during cruise flight due to fuel starvation as a result of a deteriorated fuel gasket.NTSB ENG09IA018Incident · No injuriesIncident investigationFinal reportBoeing 767 · Newark, NJFailure of Main Landing Gear (MLG) truck beam was due to contamination of the inner surface corrosion protective layers from hydraulic fluid and deice fluid that resulted in corrosion and intergranular stress corrosion cracking.NTSB CEN09CA593Accident · Minor injuriesData collectionFinal reportLinke KR-2 · Mt. Vernon, ILThe inadequate preflight planning/preparation and fuel management by the pilot which led to fuel exhaustion and a total loss of engine power during approach. Contributing to the accident was the inoperative fuel indicator.NTSB ANC09LA100Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Anchorage, AKA fatigue fracture of an unapproved hydraulic brake line fitting, which resulted in a loss of control during the landing roll. Contributing to the accident was the installation of an unapproved part by an unknown maintenance personnel.NTSB WPR09LA475Accident · No injuriesLimited investigationFinal reportWaco QCF-2 · Bend, ORThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB WPR09CA478Accident · No injuriesData collectionFinal reportCessna T210J · Albany, ORThe malfunction of the left main wheel brake during landing due to inadequate hydraulic fluid in the left brake pedal master cylinder due to leakage.NTSB ERA09LA540Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Gettysburg, PAThe failure of the left main wheel attachment fitting due to overstress.NTSB WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB ENG09IA016Incident · No injuriesIncident investigationFinal reportBoeing 767 432ER · St. Johns, CanadaIncorrect installation of a wire bundle, which contained wires for oxygen system, passenger address system and lavatory power, led to chafing of the wires on structure. The chafing eventually exposed the wire conductors and resulted in electrical arcing,…NTSB ENG09IA014Incident · No injuriesIncident investigationFinal reportBoeing 737 · Los Angeles, CAThe failure of the right main landing gear inboard axle due to fatigue cracking as a result of fretting damage in one of the brake mounting bolt holes.NTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.