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 ANC94LA056Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Circle Hot Spri, AKThe pilot-in-command's failure to maintain directional control and his lack of experience in crosswind landings.NTSB MIA94RA142Incident · No injuriesForeign investigationMcdonnell Douglas DC9-34 · Maiquetia, VenezuelaNTSB LAX94LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Santa Ana, CAthe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited experience in conventional gear aircraft.NTSB LAX94LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe student pilot's failure to maintain directional control of the aircraft.NTSB LAX94LA213Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Gridley, CAa loss of engine power due to a cracked engine cylinder head.NTSB FTW94LA185Accident · No injuriesLimited investigationFinal reportCessna 195 · Ama, LAThe pilot-in-command's failure to maintain adequate airspeed above the aerodynamic stall speed.NTSB FTW94LA151Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Elbert, COInadequate visual lookout on the part of both pilots. A factor was poor airport operations.NTSB FTW94LA148Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Lancaster, TXThe pilot's failure to use tie downs and proper assistance during the hand propping engine start.NTSB FTW94LA147Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Crystal Beach, TXThe pilot's improper autorotation touchdown, which rsulted in the hard landing. A factor was the power loss due to water contaminated fuel.NTSB CHI94LA152Accident · Minor injuriesLimited investigationFinal reportGrumman American TR-2 · Wichita, KSwas the pilot-in-command not performing an aborted landing after the first porpoise event and bounce into the air. Factors associated with this accident were an excessive airspeed and porpoising encountered by the pilot-in-command.NTSB CHI94LA150Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Sandwich, ILthe pilot in command's failure to maintain directional control during a crosswind landing and attempted go around.NTSB ATL94LA094Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Stone Mountain, GAthe pilot's improper vertical takeoff in that he allowed the helicopter to drift rearward, and his failure to maintain clearance from the wire.NTSB SEA94LA116Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dayton, WATotal failure of the connecting rod.NTSB MIA94WA134Accident · 1 fatalForeign investigationBlackmun, Larry Kitfox IV 1200 · Munjack Cay, BahamasNTSB MIA94LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Port Saint Joe, FLThe failure of the pilot to maintain airspeed resulting in an inadvertent stall. The low altitude at the time of the stall was a factor.NTSB MIA94LA131Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Crystal River, FLFailure of the pilot-in-command to maintain directional control during the landing roll.NTSB FTW94LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · High Island 334A total loss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA145Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXThe partial loss of engine power due to one magneto being weak and the other magneto arcing inside its case. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA149Accident · 2 fatalField investigationFinal reportRobl RV4 · Elbert, COAn inadvertent stall spin. A factor was the pilot's performance of aerobatic maneuvers at an inadequate altitude.NTSB ATL94FA093Accident · 1 fatalField investigationFinal reportNord 1101 · Spartanburg, SCThe pilot's failure to maintain adequate airspeed while maneuvering for an emergency landing. A factor in the accident was an inflight fire from an undetermined source.NTSB ANC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Allakaket, AKThe pilot-in-command's failure to maintain proper runway alignment after landing.NTSB SEA94T#A01Accident · No injuriesClass 3Final reportHiller UH-12E · Eugene, ORNTSB MIA94LA133Accident · No injuriesLimited investigationFinal reportCessna 170A · Boca Raton, FLThe failure of the pilot to maintain directional control.NTSB CHI94LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Chapman, NEThe pilot-in-command's attempted VFR flight into instrument weather conditions which resulted in spatial disorientation. Factors associated with the accident were the pilot-in-command's over confidence in his personal ability.NTSB ATL94LA096Accident · No injuriesLimited investigationFinal reportBeech 23-C23 · Knightdale, NCThe pilot's improper landing flare that resulted in the collapse of the nose landing gear.NTSB NYC94FA078Accident · 2 fatalField investigationFinal reportRobinson R22A · North Bergen, NJThe pilot's failure to maintain adequate visual lookout and adequate obstacle clearance, which resulted in an inflight collision with a static wire.NTSB LAX94T#A04Accident · No injuriesClass 3Final reportBell 206B · Overton, NVNTSB CHI94LA148Accident · Minor injuriesLimited investigationFinal reportNorth American T-6G · Prairie Du Sac, WIinadequate compensation for wind conditions which resulted in a failure to maintain directional control. Factors associated with the accident were the crosswind conditions and the soft terrain.NTSB CHI94LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Sikeston, MOa fatigue failure of a compressor blade which resulted in a catostrophic engine failure.NTSB ATL94IA097Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Memphis, TNThe fatigue fracture of the combustion chamber outer case. A factor was the manufacturer's inadequate inspection criteria.NTSB LAX94FA211Accident · 1 fatalField investigationFinal reportAero Commander 100 · Ocotillo Wells, CAthe failure of the pilot to maintain flying speed after experiencing a partial power failure while maneuvering. A factor in the accident was the failure of the pilot to drain accumulated water from the aircraft fuel system during the preflight inspection.NTSB FTW94LA144Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Osage, ARFuel exhaustion due to the pilot's failure to refuel and the lack of suitable terrain for a forced landing.NTSB CHI94LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Alexandria, NEThe pilot's failure to maintain clearance with wires.NTSB NYC94LA084Accident · No injuriesLimited investigationFinal reportCessna 421A · Richlands, VAThe hard landing, as a result of the pilot's misjudged rate of descent. A factor related to the accident was the pilot's limited experience in this make and model airplane.NTSB NYC94LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTThe student pilot's improper recovery from a bounced landing which resulted in a loss of directional control. A factor was the student pilot's imroper landing flare, which resulted in a hard landing.NTSB LAX94LA210Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-34 · Hemet, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin. A factor in the accident was the pilot's low total flight time.NTSB CHI94LA146Accident · No injuriesLimited investigationFinal reportCessna P210N · Bay City, MIThe pilot-in-command not following the airplane pre-landing checklist and the delay in landing gear extension.NTSB ATL94IA092Incident · No injuriesIncident investigationFinal reportSaab-Scania S340B · Nashville, TNEngine ice/slush ingestion that resulted in power interruptions and failure of the air data computer coupled with moisture ingestion of the static system. Factors were the failure of the manufacturer to correct a previously identified design deficiency that…NTSB SEA94LA114Accident · No injuriesLimited investigationFinal reportCessna 150K · Chehalis, WAThe pilot's inadequate compensation for wind conditions. A factor to the accident was: crosswind.NTSB NYC94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Danbury, CTThe student pilot's inadequate compensattion for wind conditions. The crosswind was a factor.NTSB LAX94LA208Accident · No injuriesLimited investigationFinal reportBell UH-1L · Pleasant Grove, CAthe pilot's failure to see and avoid the power lines due to sun glare from the rising sun at dawn.NTSB LAX94LA207Accident · 1 fatalLimited investigationFinal reportGriffin Titan Tornado · Buckeye, AZthe pilot's failure to maintain control of the aircraft. A factor in the accident was his complete lack of any flight experience or instruction.NTSB LAX94FA212Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · La Verne, CAThe pilot's selection of a flight route and en route descent altitude insufficient to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night light condition and the mountainous terrain.NTSB CHI94LA144Accident · No injuriesLimited investigationFinal reportHelio H-800 · Foley, MNThe pilot-in-command's failure to perform accurate fuel consumption calculations. A factor was the soft gravel road landing area.NTSB CHI94FA155Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Mcintosh, SDVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) from rising terrain. Factors related to the accident were: failure of the pilot to update his weather…NTSB ANC94LA053Accident · No injuriesLimited investigationFinal reportBeech 35 · Gustavus, AKThe pilot-in-command's delay in selecting the main fuel tank position. The lack of suitable terrain for a forced landing was a factor.NTSB MIA94LA129Accident · Serious injuriesLimited investigationFinal reportTaylor Osprey · Sanford, FLThe failure of the pilot in command to use the checklist before takeoff. The engine failed due to the fuel selector being in the off position. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB LAX94LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Phoenix, AZthe pilot's failure to ensure that the magneto switch was in the off position prior to rotating the propeller by hand.NTSB FTW94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lindon, COInaccurate preflight planning and preparation for the flight. A factor was soft terrain on the landing strip.NTSB FTW94FA141Accident · 2 fatalField investigationFinal reportMooney M20E · Broomfield, COFatigue failure of the engine crankshaft; and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a stall and collision with the terrain. Factors related to the accident were: the undesirable engine/propeller…