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 CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.NTSB CHI00FA006Accident · Serious injuriesField investigationFinal reportDassault DA-900B · Holland, MIThe copilot's improper use of the autopilot system while leveling the flight from descent, resulting in an inadvertent pilot-induced pitch oscillation of the airplane. A factor was the flight attendant not wearing a seat belt at the time of the occurrence.NTSB NYC00LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hoffmeister, NYThe pilot failure to maintain directional control while step-taxiing. A factor in the accident was gusty winds.NTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.NTSB LAX00TA006Accident · No injuriesFinal reportMcDonnell Douglas 369E · Moreno Valley, CAThe failure of the pilot to maintain sufficient forward airspeed to preclude an inadvertent encounter with loss of tail rotor effectiveness, which resulted in a loss of yaw control. The pilot's failure to initiate timely remedial action is a factor.NTSB LAX00LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Torrance, CAThe pilot's excessive airspeed on final approach and his misjudged flare, which resulted in a uncontrolled porpoise and hard landing.NTSB NYC00LA024Accident · No injuriesLimited investigationFinal reportCessna 177 · Frankfort, KYA total loss of engine power for undetermined reasonsNTSB NYC00LA007Accident · No injuriesLimited investigationFinal reportBoeing - Canada DHC-8-102 · Philadelphia, PAAn in flight collision with birds.NTSB LAX00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Apache Junction, AZOil starvation and seizure of the engines Nos. 6 and 7 bearings due to a clogged oil jet, which resulted in a total loss of engine power.NTSB FTW00TA007Accident · No injuriesFinal reportBell 206B · Slaton, TXThe pilot's initiation of the simulated emergency procedure at a low altitude.NTSB FTW00LA008Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Bay City, TXThe pilot's inadvertent stall. A factor was the pilot's encounter with the airplane's wake turbulence.NTSB ANC00LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe failure of the driver of the forklift to maintain an adequate visual outlook.NTSB ANC00LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Yakutat, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.NTSB LAX00LA005Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Tonopah, NVThe pilot's failure to monitor his altitude and maintain an adequate terrain clearance during the approach. The dark night lighting conditions and the visual illusion created by the lack of ground reference lights were factors in the accident.NTSB CHI00LA005Accident · No injuriesLimited investigationFinal reportZenair CH 2000 · St. Louis, MOthe student pilot misjudged the landing flare which resulted in a hard landing. A factor associated with the accident was the student's lack of total experience.NTSB NYC00LA005Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-11F · Newark, NJA divergent, longitudinal oscillation of undetermined origin on the center landing gear, which caused a failure of the center landing gear lower drag brace during landing roll.NTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.NTSB MIA00FA003Accident · 2 fatalField investigationFinal reportBell 206B · Centreville, ALThe pilot's inadequate preflight inspection of the helicopter's fuel system resulting in an in-flight loss of engine power due to fuel exhaustion as a result of overboard porting of fuel when the airframe fuel filter was left in the 'drain and locked'…NTSB LAX00LA004Accident · No injuriesLimited investigationFinal reportCessna 421B · Montague, CAThe collapse of the left main landing gear during the landing rollout for undetermined reasons, which resulted in the pilot's loss of directional control.NTSB FTW00LA006Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M18 · Weldon, ARThe cause of the accident was undetermined.NTSB FTW00LA005Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Brownfield, TXThe pilot's failure to maintain clearance with power wires while maneuvering during an aerial application flight. A factor was the sunglare.NTSB NYC00FA004Accident · 1 fatalField investigationFinal reportCessna 182R · Killingworth, CTThe pilot's failure follow the published instrument approach procedure. A factor in the accident was the low cloud ceiling.NTSB FTW00LA004Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL-105G · Mcalester, OKThe pilot's continued flight into known adverse weather, which resulted in a hard landing. Factors were the thunderstorms, dark night light conditions, and the high winds.NTSB CHI00LA004Accident · 2 fatalLimited investigationFinal reportDraper Rans S-10 · Benton, KSthe pilot inadvertently stalled the airplane. Factors relating to the accident was the undetermined loss of power and the pilot's lack of recent experience in the airplane.NTSB NYC00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Greenville, METhe pilot's inadequate preflight planning and his inadequate visual lookout.NTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB LAX00LA003Accident · Serious injuriesLimited investigationFinal reportGiles G-750 · Salinas, CAthe pilot's failure to maintain an adequate airspeed while maneuvering, which led to a stall/mush condition.NTSB CHI00LA001Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Greenwood, INundetermined.NTSB ANC00LA001Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot's inadequate preflight inspection to remove all contaminated fuel from the fuel system. A factor associated with the accident was an unsuitable terrain condition for landing.NTSB NYC00LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA total loss of engine power for undetermined reasons.NTSB NYC00FA001Accident · Serious injuriesField investigationFinal reportCessna 401B · Caldwell, NJThe pilot's inadequate preflight, which resulted in an attempted takeoff with the pitot covers installed. An additional cause was the pilot's delayed decision to abort the takeoff, while factors included the misleading airspeed indications, and the proximity…NTSB MIA00WA002Accident · No injuriesForeign investigationTemco DA-16A · Freeport, BahamasNTSB LAX00LA002Accident · No injuriesLimited investigationFinal reportZdybel Glasair FT · Rio Linda, CAFuel starvation due to the owner/builder's improper installation of the fuel selector valve, and, his failure to placard the operating positions of the valve handle.NTSB LAX00LA001Accident · No injuriesLimited investigationFinal reportIsmari Canard C3A · Henderson, NVA partial loss of engine power for undetermined nonmechanical reasons. A contributing factor was the rough nature of the terrain used for the forced landing.NTSB FTW00RA003Accident · 12 fatalForeign investigationBell 214ST · Dhahran, Saudi ArabiaNTSB FTW00FA001Accident · 2 fatalField investigationFinal reportCessna P210N · Spicewood, TXThe pilot's delayed application of full throttle during a go-around, which resulted in a slow airspeed and inadvertent stall/spin. A factor was the pilot's habit of only applying partial power during takeoff.NTSB DEN00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Las Cruces, NMThe pilot's inadvertent ground loop/swerve during landing. A factor was his attention being diverted by a malfunctioning throttle control.NTSB DEN00LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · La Junta, COThe pilot-in-command's failure to maintain a proper altitude during final approach to landing, and his misjudgment of altitude clearances. Factors were the sudden windshift, downdraft and turbulent weather conditions, the dark night, and the pilot's lack of…NTSB CHI00LA002Accident · Minor injuriesLimited investigationFinal reportEnstrom EN-28 · Indianapolis, INThe pilot's attempted operation of the helicopter with known deficiencies, and his improper autorotation to landing. Factors were one fouled spark plug and another partially failed spark plug in the same cylinder, and the construction area.NTSB SEA00FA001Accident · Minor injuriesField investigationFinal reportde Havilland DHC-2 Mark 1 · Port Blakely, WAThe pilot-in-command's failure to maintain adequate clearance from trees/terrain. Contributing factors were rising terrain and trees.NTSB FTW99LA272Accident · 1 fatalLimited investigationFinal reportCessna 150F · Poteau, OKThe instructor pilot's inadequate in-flight decision making, which resulted in the continued flight with a disabled generator and subsequent total failure of the electrical system. Factors were the installation of the inadequate generator fuse by unknown…NTSB FTW00LA002Accident · No injuriesLimited investigationFinal reportCessna 210L · Fayetteville, ARThe cause of the right main gear collapse was undetermined. A factor was the failure of the gear 'down & locked' switch resulting in a false 'down & locked' indication in the cockpit.NTSB DEN00LA001Accident · Serious injuriesLimited investigationFinal reportGray Rotorway Exec · Gallup, NMThe pilot inadvertently allowing main rotor rpm to decay while avoiding obstacles during an emergency autorotation following a loss of power for reasons undetermined. Factors were houses and powerlines.NTSB CHI00FA003Accident · 1 fatalField investigationFinal reportBeech D-45 · Oswego, ILthe visual lookout not obtained by the pilot of the Beech T-34 and the inadequate procedure by the Lima Lima Flying Squadron. The delayed entry into the maneuver by the pilot of the Beech D-45 was a contributing factor.NTSB NYC99LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie 319-131 · Sparta, NJThe airplane's encounter with clear air turbulence.NTSB FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB FTW00LA013Accident · No injuriesLimited investigationFinal reportChampion 7FC · Powderly, TXThe pilot's inadequate preflight inspection of the airplane, during which he failed to detect the disconnected tailwheel steering assembly.NTSB DEN99LA173Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Longmont, COAn inaccurate touchdown during a full autorotation, which resulted in main rotor flex which cut off the tail boom. Factors were the pilot's lack of total experience in helicopters and high density altitude.NTSB DEN99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COAn encounter with a sudden tailwind gust windshift during landing roll, resulting in an inadvertent ground loop.NTSB CHI99LA357Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Greenfield, INthe FBO employee improperly refueled the airplane with Jet A fuel instead of 100LL and the inadequate preflight by the pilot-in-command in that he failed to drain the fuel tanks during the preflight. Factors related to the accident were the low altitude at…