NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 WPR11CA293Accident · No injuriesData collectionFinal reportAviat A-1B · Livermore, CAThe pilot's failure to maintain directional control during a go-around.NTSB ERA11CA364Accident · Minor injuriesData collectionFinal reportHelio H-295 · Brasstown, NCThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11LA426Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphia, OHThe pilot's incorrect identification of the wind direction before landing, which resulted in a tailwind landing and subsequent runway excursion.NTSB CEN11LA419Accident · No injuriesLimited investigationFinal reportVanDenburg Pietenpol Air Camper · Gwinn, MIThe pilot’s loss of directional control during the landing roll, which resulted in a ground loop.NTSB CEN11LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Rantoul, ILThe pilot did not use the emergency landing gear extension system, which resulted in a wheels-up landing. Contributing to the accident was the inoperative landing gear power pack motor.NTSB WPR11LA284Accident · No injuriesLimited investigationFinal reportCessna 172S · Palo Alto, CAA total loss of engine power for undetermined reasons during the landing approach over unsuitable terrain.NTSB WPR11LA283Accident · No injuriesLimited investigationFinal reportBeech A36 · El Monte, CAThe pilot's failure to maintain adequate airspeed during the forced landing, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the loss of engine power due to fuel starvation as a result of the pilot's improper fuel…NTSB WPR11CA286Accident · No injuriesData collectionFinal reportAir Tractor AT301 · Circle, MTThe pilot's failure to attain and maintain an adequate airspeed during initial climb.NTSB CEN11WA446Accident · 1 fatalForeign investigationRobinson R44 · Schefferville, CanadaOn June 24, 2011, about 0806 eastern daylight time, a Canadian registered Robinson R44 Raven II, C-FSKV, operated by Capital Helicopter, sustained substantial damage when it crashed on final approach to land near Lac Deborah, Schefferville, Quebec. The pilot…NTSB CEN11FA417Accident · 2 fatalField investigationFinal reportBeech A36 · Charlevoix, MIThe pilot's inadequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to not execute a missed approach in weather conditions below minimums.NTSB CEN11CA438Accident · No injuriesData collectionFinal reportCessna A188 · Castroville, TXThe pilot's failure to maintain obstacle clearance during the agricultural spraying flight.NTSB CEN11CA423Accident · No injuriesData collectionFinal reportHendricks George David JR RV8 · Angel Fire, NMThe pilot's loss of directional control during landing.NTSB WPR11WA297Accident · 1 fatalForeign investigationHitchcock Christen Eagle II · Padang, West Sumatera, IndonesiaOn June 23, 2011 at 1020 universal coordinated time, a Hitchcock Christen Eagle II, N21H, collided with the terrain while performing an aerobatic maneuver at Tabing Airfield, Padang, West Sumatera. The pilot was fatally injured and the airplane was…NTSB WPR11LA282Accident · No injuriesLimited investigationFinal reportHiller UH12E · Hanford, CAThe separation of the tail rotor drive gear shaft due to torsional fatigue of its threaded portion, which resulted in a loss of tail rotor control.NTSB WPR11LA279Accident · Serious injuriesLimited investigationFinal reportRockwell International S-2R · Brawley, CAThe partial loss of engine power shortly after takeoff, which likely resulted from the failure of the piston connecting rod in cylinder number 3 due to hydraulic lock in that cylinder.NTSB WPR11CA281Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Havre, MTThe pilot's failure to maintain directional control during takeoff.NTSB ERA11WA368Accident · 3 fatalForeign investigationCirrus SR20 · Cairo Montenotte, ItalyOn June 23, 2011, about 1000 UTC, a Cirrus SR20, Luxembourg registration LX-MPR, operated by a private individual, collided with mountainous terrain near Cairo Montenotte, Italy. Instrument meteorological conditions prevailed in the area at the time and…NTSB ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.NTSB ERA11LA357Accident · No injuriesLimited investigationFinal reportCessna 182F · Warrenton, VAThe fatigue failure of the left main landing gear due to inadequate maintenance inspection that did not detect and correct corrosion pitting.NTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.NTSB CEN11LA457Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Akron, COThe mixture control cable disconnected from the cable housing attach clamp, which resutlted in the pilot's inability to add power when needed.NTSB CEN11LA414Accident · No injuriesLimited investigationFinal reportEnstrom F-28C-2 · Blair, NEThe failure of a tail rotor pitch change link due to the retaining bolt becoming separated in flight. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.NTSB WPR11LA280Accident · No injuriesLimited investigationFinal reportInhofe/ Davis Vans RV-8 · Sheridan, WYThe pilot's inadequate directional control during the landing roll.NTSB ERA11CA367Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Miami, FLThe in-flight encounter with convective turbulence, resulting in an injury to a cabin attendant.NTSB CEN11LA421Accident · 2 fatalLimited investigationFinal reportUltralight America Spitfire II · Ranger, TXThe pilot’s failure to maintain sufficient airspeed during the initial climb after a takeoff in high density altitude conditions, which resulted in an inadvertent stall.NTSB WPR11TA274Accident · No injuriesFinal reportBell 206B · Franklin, CAThe student pilot's failure to maintain rotor rpm during the practice autorotation.NTSB WPR11LA292Accident · No injuriesLimited investigationFinal reportCessna 320F · Phoenix, AZThe mechanic's failure to properly secure the nose landing gear actuator push-pull tube to the landing gear door hinge clevis, which resulted in the gear jamming and not fully retracting after takeoff.NTSB WPR11LA278Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Blackfoot, IDA partial loss of engine power during takeoff for undetermined reasons.NTSB WPR11LA277Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mesa, AZThe pilot's failure to maintain helicopter control while in a low hover.NTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.NTSB WPR11LA272Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Hogeland, MTCollision with the ground while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.NTSB ENG11IA035Incident · Minor injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAFuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…NTSB WPR11LA269Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Caldwell, IDThe total loss of power in one engine during takeoff due to the blockage of fuel flow by a foreign object in the fuel tank.NTSB WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.NTSB ERA11CA358Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Linwood, NJThe pilot's improper brake application during the landing roll which resulted in a nose over.NTSB ERA11CA355Accident · No injuriesData collectionFinal reportDotson William P Sngl Seat Hawk Arrow · Carthage, NCA partial loss of engine power due to the pilot’s improper installation of the engine’s No. 1 cylinder spark plugs.NTSB ANC11CA052Accident · No injuriesData collectionFinal reportCessna 182H · Soldotna, AKThe pilot's failure to maintain pitch control resulting in an aerodynamic stall.NTSB WPR11WA285Accident · Serious injuriesForeign investigationBell 407 · Ladpur, India, IndiaOn June 19, 2011, at 0854 universal coordinated time, a Bell 407, VT-SWA, crashed during landing at Ladpur, Dehradun, India. The pilot and passenger were seriously injured and the helicopter was substantially damaged. The helicopter was operated by M/s Swajas…NTSB WPR11LA270Accident · 1 fatalLimited investigationFinal reportSix Chuter Skye Ryder Aerochute · Tooele, UTThe operation of a powered parachute by a non-certificated pilot. Contributing to the accident was the pilot's decision to conduct a flight in a strong gusty wind.NTSB WPR11LA267Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lost Hills, CAThe failure of the engine-driven fuel pump, resulting in the loss of all engine power and the pilot's failure to correctly execute an autorotational landing.NTSB OPS11IA673Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145EP · Gulfport, MSthe Gulfport control tower local controller cleared two aircraft for takeoff from runways with intersecting departure flight paths without ensuring the first aircraft had passed the flight path intersection prior to clearing the second aircraft for takeoff.NTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.NTSB ERA11CA352Accident · No injuriesData collectionFinal reportPiper PA18-160 · Ridgeville, SCA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…NTSB CEN11FA401Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Columbus, OHThe pilot's spatial disorientation during the takeoff into instrument meteorological conditions, which resulted in his failure to maintain control of the airplane.NTSB CEN11CA409Accident · No injuriesData collectionFinal reportCessna 172N · Santa Teresa, NMThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.NTSB WPR11LA266Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mount Pleasant, UTThe pilot’s failure to determine the airplane’s fuel quantity before takeoff, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR11LA265Accident · No injuriesLimited investigationFinal reportAerovodochody L-29 Delfin · Reno, NVThe failure of a modified engine mount to keep the engine properly aligned, which resulted in partial failure of the rudder support structure due to the deflection of the jet engine exhaust.