NTSB investigations, 2008
286 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
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\") = 2008
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") = 2008 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 CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.NTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.NTSB ERA09CA112Accident · No injuriesData collectionFinal reportMichael Muratore Vans · Bayport, NYThe pilot's failure to stop the airplane within the available runway after touchdown. Contributing to the accident were the failure of the flap system as reported by the pilot and the damp grass.NTSB CEN09LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Palenstine, TXThe failure of the pilot to ensure security of the cockpit switches before rotating the propeller.NTSB ERA09WA214Accident · No injuriesForeign investigationPiper PA31-350 · Lorenzo, BrazilOn March 23, 2009, at 1700 Atlantic standard time, a Piper PA31-350 Chieftain, PT-EHG, sustained minor damage from a landing-gear brake fire after landing at Lorenzo Airport (SNCL), Cairu, Brazil. The pilot and seven passengers were not injured. Visual…NTSB ERA09LA111Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works SportCruiser · Emporia, VAThe student pilot's failure to maintain directional control during the landing. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information.NTSB CEN09CA118Accident · No injuriesData collectionFinal reportSocata TBM 700 · Clovis, NMThe pilot's failure to complete the before-landing checklist, which led to his failure to lower the gear before landing.NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.NTSB CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.NTSB ERA09LA282Accident · No injuriesLimited investigationFinal reportDassault/Sud FAN JET · Jamestown, NYThe inability to stop the airplane on the remaining runway because of icy runway conditions. A factor was the failure of the drag chute to properly deploy.NTSB DCA09MA021Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-524 · Denver, COThe captain’s cessation of right rudder input, which was needed to maintain directional control of the airplane, about 4 seconds before the excursion, when the airplane encountered a strong and gusty crosswind that exceeded the captain’s training and…NTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.NTSB DCA09IA017Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAthe failure of the maintenance personnel to properly complete the installation, and the inspection personnel to conduct the proper functional test, of the left main landing gear uplock assembly.NTSB CEN09FA087Accident · 1 fatalField investigationFinal reportBeech C90 · Rocksprings, TXThe pilot's failure to properly configure the pressurization controls, resulting in his impairment and subsequent incapacitation due to hypoxia.NTSB ERA09IA115Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLThe airplane manufacturer's inadequate inspection procedure resulting in undetected fatigue cracking of the main landing gear barrel of the upper barrel and trunnion assembly.NTSB DCA09IA018Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD88 · Greer, SCThe overheating and arcing of the DC Ground Service Relay and Block Diodes component 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 CEN09CA084Accident · No injuriesData collectionFinal reportRockwell International 114 · Meacham Int'l Airport, TXThe pilot's failure to maintain pitch control during landing.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB WPR09LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Monterey, CAThe pilot's inadequate fuel system management and inflight planning that led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to use the landing checklist.NTSB CEN09CA078Accident · No injuriesData collectionFinal reportCessna 172S · Waukesha, WIThe pilot's failure to maintain aircraft control during takeoff and his failure to ensure that the elevator trim was properly set before takeoff. Contributing to the accident was the pilot's lack of autopilot system knowledge.NTSB WPR09LA048Accident · No injuriesLimited investigationFinal reportHughes 369HS · Fillmore, UTThe loss of engine power due to fuel starvation as a result of a loose fuel filter upper drain cap, which was not properly secured by maintenance personnel.NTSB ERA09FA068Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T4 · Whites Creek, TNThe pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…NTSB WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.NTSB CEN09CA119Accident · No injuriesData collectionFinal reportPiper Aerostar 6 · Middletown, OHThe pilot's failure to verify that the landing gear was down and locked prior to landing.NTSB ERA09CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Cleveland, MSThe pilot's failure to lower the landing gear prior to touchdown.NTSB ERA09IA056Incident · No injuriesIncident investigationFinal reportDeHavilland DHC-8-311 · Philadelphia, PAThe mechanical overload of the nosewheel steering links for undetermined reasons, which resulted in nose landing gear rotation and its subsequent wedging within the wheel well structure.NTSB WPR09CA101Accident · No injuriesData collectionFinal reportBeech K35 · Port Townsend, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a checklist and the distraction caused by the discussion with the passenger.NTSB CEN09CA058Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe failure of the pilot to lower the gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB CEN09IA057Incident · No injuriesIncident investigationFinal reportCessna T210N · Lubbock, TXAn unidentified anomaly within the airplane's electrical system. Contributing to the incident was the pilot's failure to manually extend the landing gear.NTSB CEN09LA051Accident · Serious injuriesLimited investigationFinal reportJohnson Leonard G Cozy MK-IV · Osceola, MOA total loss of engine power due to an obstruction of airflow as a result of the pilot's inadvertent actuation of the landing brake.NTSB ERA09LA050Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe failure of the nose gear drag link bolt due to reversed bending fatigue.NTSB CEN09CA045Accident · No injuriesData collectionFinal reportHartter Lenny J Bearhawk · Mack, COThe collapse of the left main landing gear which resulted in the pilot's failure to maintain directional control.NTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.NTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.NTSB ERA09LA057Accident · No injuriesLimited investigationFinal reportCampbell Earl S JR RV-6A · Cambridge, MDThe failure of the RV-6A's right brake assembly o-ring due to excessive heat.NTSB WPR09CA017Accident · No injuriesData collectionFinal reportPiper L-4 · Buckeye, AZAnother airplanes total loss of wheel brakes while taxing which resulted in the pilot of the other aircraft colliding with a standing aircraft. Contributing to the accident was the other airplanes low brake hydraulic fluid.NTSB CEN09IA032Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Amherst, TXThe failure of the vertical stabilizer control adapter due to reverse bending fatigue.NTSB CEN09LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Silverton, TXThe pilot's failure to maintain clearance from a transmission wire.NTSB CEN09CA020Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lufkin, TXThe student pilot's improper decision to takeoff with a known brake problem. Contributing to the accident were the malfunctioning brake and the rough terrain in the excursion area.NTSB WPR09FA005Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian SKY Arrow 600 · Malibu, CAThe pilot's failure to maintain aircraft control during a low-altitude maneuver. Contributing to the accident was the pilot's decision to perform a maneuver at a low altitude that was insufficient to allow him to recover from the loss of control. Contributing…NTSB CEN09IA003Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Weatherford, TXThe failure of the vertical stabilizer control adapter due to reverse bending fatigue.NTSB ERA09IA009Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Lakeland, FLA failure of the flap actuator rod end due to low stress, high cycle fatigue, and subsequent overstress failure.NTSB ERA09LA004Accident · No injuriesLimited investigationFinal reportCessna T210M · Savannah, GAA loss of engine power in flight due to fuel exhaustion as a result of the pilot's improper fuel management.NTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.NTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.NTSB ERA09CA006Accident · No injuriesData collectionFinal reportBeech F17D · Moscow, TNThe mechanical failure of the landing gear actuation chain.NTSB ANC09LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB SEA08LA216Accident · No injuriesLimited investigationFinal reportBrennan RV-8 · Idaho Falls, IDThe on-ground fire during taxi due to a loose fuel line "B" nut.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.