NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 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 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 WPR09CA099Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bisbee, AZThe student pilot's failure to maintain directional control during takeoff and the flight instructor's inadequate supervision of the flight and delay in remedial action.NTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.NTSB ERA09IA140Incident · No injuriesIncident investigationFinal reportCessna 402C · Naples, FLThe pilot's failure to recognize that both engines were being supplied fuel only from the right main fuel tank, resulting in fuel starvation and a subsequent loss of engine power from both engines. Contributing to the incident were the pilot's inability to…NTSB CEN09LA143Accident · No injuriesLimited investigationFinal reportCessna 172E · Plano, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA09LA139Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Monroe, NCThe pilot-rated-passenger’s failure to maintain clearance from a known wire hazard during low-level maneuvering. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the flight.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.NTSB WPR09LA097Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Honolulu, HIAn oil starvation induced catastrophic engine failure due to the fracture and separation of the propeller governor oil line, which was a result of inadequate inspection by maintenance personnel.NTSB WPR09CA095Accident · No injuriesData collectionFinal reportDickson Vans RV-8 · El Monte, CAThe pilot's failure to maintain directional control during landing.NTSB CEN09LA154Accident · Serious injuriesLimited investigationFinal reportUltra Flight Challenger · Waldron, MOThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident were the pilot's lack of experience in the make and model of airplane, the inoperative flight instruments and the pilot's failure to abort…NTSB ERA09CA138Accident · No injuriesData collectionFinal reportMD Helicopter 369E · Atlanta, GAWind gusts during engine shutdown, which resulted in the main rotor blades contacting the tailboom.NTSB WPR09CA092Accident · No injuriesData collectionFinal reportRyan Navion · Three Forks, MTA total loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel system management. Contributing to the accident were the pilot's diverted attention and failure to perform the prelanding checklist.NTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.NTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB WPR09CA091Accident · No injuriesData collectionFinal reportSiemer James H Earthstar · Santa Ynez, CAA partial loss of engine power due to the rear cylinder's spark plug coming out of the cylinder head.NTSB WPR09CA090Accident · Minor injuriesData collectionFinal reportMulec Frank A FP-404 · Hilo, HIA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.NTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.NTSB ERA09CA136Accident · No injuriesData collectionFinal reportMaule MX-7-180C · Akron, ALThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB CEN09LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMCollapse of the landing gear during landing due to the incorrect installation of the landing gear actuator. Contributing to the accident was the pilot's failure to initiate the abnormal procedures checklist prior to landing.NTSB CEN09CA141Accident · No injuriesData collectionFinal reportCessna 172S · Emporia, KSThe pilot's inadequate compensation for the wind conditions during the touch-and-go. Contributing to the accident were the gusty crosswinds.NTSB CEN09CA136Accident · No injuriesData collectionFinal reportBeech 19 · Lafayette, INThe pilot's inadvertent encounter with icing conditions during initial climb. Contributing to the accident were the lack of visibility during the landing due to an ice covered windscreen, and the structural ice that adversely affected the flight…NTSB WPR09CA088Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S R582 · Ventura, CAThe pilot's failure to maintain clearance from the water.NTSB ERA09LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, GAA total loss of engine power for an undetermined reason.NTSB WPR09FA089Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-400 · Volcano, HIThe pilot's loss of pitch control and subsequent exceedance of the glider's airspeed limit for undetermined reasons.NTSB WPR09CA094Accident · No injuriesData collectionFinal reportJones Rodney V Wittman TA · Yucca Valley, CAA loss of directional control due to a weld joint failure of the left rudder pedal.NTSB ERA09CA135Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Merritt Island, FLThe pilot's failure to maintain aircraft control during landing in windy conditions.NTSB WPR09LA085Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Beaver, UTA loss of engine power while maneuvering due to a sheared propeller blade's pitch change link. Contributing to the accident was lack of suitable terrain for the forced landing.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 CEN09FA135Accident · 3 fatalField investigationFinal reportGulfstream Aerospace Commander · Wray, COThe pilot’s failure to maintain aircraft control during the approach resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s improper preflight planning and conditions conducive for structural icing.NTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.NTSB WPR09CA084Accident · No injuriesData collectionFinal reportCessna U206E · Crane Island, San Juan Is., WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB CEN09CA133Accident · Minor injuriesData collectionFinal reportBrantly B-2B · Cement, OKThe pilot's failure to maintain proper airspeed and descent rate during approach, which resulted in a hard landing. Contributing to the accident were the nearby power lines.NTSB ERA09CA134Accident · Serious injuriesData collectionFinal reportPiper PA-32R-300 · Manteo, NCThe pilot's failure to follow the missed approach procedure while landing with a low ceiling.NTSB WPR09LA079Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Corona, CAThe pilot's inadequate compensation for the gusting wind conditions and failure to maintain directional control during the takeoff-initial climb.NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.NTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB DCA09WA023Incident · No injuriesForeign investigationBoeing 737 · East Anglia, United KingdomOn January 12, 2009, at 1545 Coordinated Universal Time, an easyJet Boeing 737-73V, registered in the United Kingdom as G-EZJK, experienced a violent pitch down during flight. Vmo was exceeded by 100 knots, and a 10,000 foot loss of altitude occurred. The…NTSB CEN09LA128Accident · 1 fatalLimited investigationFinal reportProbst Baby Ace D · Kilgore, TXA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning. Contributing to the accident was the pilot's failure to maintain situational awareness, resulting in him being lost.NTSB CEN09CA127Accident · No injuriesData collectionFinal reportEurocopter AS350 · Vermillion 229The pilot's failure to maintain clearance from a known obstruction. Contributing to the accident was the location/placement of lightning rods in the landing zone.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 CEN09FA126Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Hayden, COThe pilot's loss of control due to snow/ice contamination on the airplane's lifting surfaces as a result of his decision not to deice the airplane before departure.NTSB CEN09CA131Accident · No injuriesData collectionFinal reportCessna 150M · Sellersburg, INThe student pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall at a low altitude. An additional cause was the flight instructor's delayed remedial action.NTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.NTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.NTSB ERA09WA212Incident · No injuriesForeign investigationPiper PA28R · Rio Verde, BrazilNone.NTSB CEN09CA130Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Elrosa, MNThe pilot's inability to maintain control after touchdown on a snow-covered runway.NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.NTSB WPR09FA076Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R44 II · West Valley City, UTThe pilot’s inadvertent VFR flight into IMC conditions, which resulted in his spatial disorientation and loss of control of the helicopter. Also causal was the flight instructor’s delay in taking remedial action.NTSB WPR09CA081Accident · No injuriesData collectionFinal reportParker 77 · Phoenix, AZThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.NTSB CEN09LA134Accident · Serious injuriesLimited investigationFinal reportInman J D Kolb Mark III · Ozark, ARThe loss of engine power due to fuel contamination. Contributing to the accident was the pilot maintaining a high angle of attack during takeoff, which resulted in an inadvertent stall when the engine failed.