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 MIA04FA060Accident · 1 fatalField investigationFinal reportCessna 182P · Spring Hill, FLThe non instrument rated pilot's decision to attempt VFR flight into IMC conditions resulting in an in-flight loss of control.NTSB LAX04TA161Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · Safford, AZA loss of engine power due to fuel starvation and at least one ensuing engine power surge, which caused the airplane to pitch up abruptly into a stall at an altitude too low for recovery. Contributing to the accident were the pilot's mismanagement of the fuel…NTSB FTW04LA095Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Galveston, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's failure to evaluate the wind, prior to landing downwind.NTSB LAX04LA158Accident · No injuriesLimited investigationFinal reportQuinn E L Tom Cat MK-5A · Galt, CAa loss of engine power due to water contamination of the fuel system.NTSB FTW04LA092Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Conroe, TXThe loss of engine power due to the improper fuel type. Contributing factors were the improper aircraft servicing, lack of training by the fixed base operator, and the low cloud ceiling.NTSB DEN04LA052Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Monticello, UTthe pilot's failure to maintain aircraft control during takeoff. Contributing factors include the sudden windshift and the bushes.NTSB CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…NTSB SEA04LA055Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Cusick, WAThe pilot's failure to adequately compensate for crosswind conditions and his failure to maintain proper alignment in the direction of landing during the touchdown portion of a water landing on a river. Factors include crosswind conditions.NTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.NTSB NYC04LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Turner, METhe pilot's misjudgment of speed/distance and the delayed aborted landing. A factor in this accident was the tail wind condition.NTSB LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.NTSB FTW04WA170Accident · No injuriesForeign investigationCessna 180K · San Felipe, MexicoNTSB MIA04LA062Accident · No injuriesLimited investigationFinal reportBeech BE90 · Fort Lauderdale, FLThe inadequate inspection of the landing gear system by company maintenance personnel resulting in a crack in the left main landing actuator mount going undetected and collapse of the left landing gear during landing roll when the actuator attachment failed.NTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.NTSB LAX04CA155Accident · No injuriesData collectionFinal reportJerry Garrison Christen Eagle II · Hollister, CAthe pilot's failure to obtain proper runway alignment and maintain clearance from a sign due to his inadequate visual lookout. Factors in the accident were crosswind conditions.NTSB FTW04LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plain Dealing, LAA loss of engine power due to undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA065Accident · No injuriesLimited investigationFinal reportMooney M20C · Clovis, NMthe pilot's improper in-flight planning and decision making during an instrument approach resulting in the pilot's intentional descent below approach minimums, and the pilot's failure to maintain obstacle clearance resulting in the in-flight collision with an…NTSB CHI04LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Peru, ILThe inadvertent landing gear retraction by the dual student during the landing roll.NTSB ATL04LA084Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · Plains, GAThe pilot's misjudgment of the speed/distance/altitude which resulted in a overrun of the runway.NTSB MIA04LA058Accident · 1 fatalLimited investigationFinal reportOrtmayer/Parson none · Bunnell, FLThe owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.NTSB MIA04CA059Accident · No injuriesData collectionFinal reportRobinson R22 · Keystone, FLThe inadequate supervision by the flight instructor by allowing the student to lose excessive altitude resulting in a skid impacting the ground and subsequent roll over of the helicopter.NTSB LAX04FA165Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Napa, CAThe pilot's failure to maintain control of the airplane following a shutdown of the left engine during a night visual approach. A factor contributing to the accident was the dark night.NTSB LAX04CA154Accident · Minor injuriesData collectionFinal reportAyres S-2R · Los Banos, CAthe pilot's failure to maintain proper runway alignment due to visual restrictions from the light condition, resulting in a nose over. Factors in the accident were the dusk light conditions and sun glare.NTSB ENG04RA014Incident · No injuriesForeign investigationDassault Fanjet Falcon · Roeros, NorwayNTSB ANC04LA030Accident · No injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe pilot's inadequate compensation for a crosswind condition during the landing roll, which resulted in a loss of control, and an on ground collision with a snow bank. A factor associated with the accident was a crosswind.NTSB MIA04IA056Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Fort Lauderdale, FLThe flight crews' inadvertent setting of the parking brake during flight resulting in the airplane being landed with the parking brake set and failure of all 8 main landing gear tires during the landing rollout.NTSB LAX04CA160Accident · No injuriesData collectionFinal reportCessna C195A · Gila Bend, AZthe pilot's failure to maintain directional control, resulting in a ground loop. Factors in the accident were the pilot's unfamiliarity with the airplane and the delayed remedial action of the flight instructor.NTSB LAX04CA153Accident · No injuriesData collectionFinal reportAyres S2R-600 · Calipatria, CAthe failure of ground personnel to refuel the airplane with the proper fuel grade/octane, resulting in the airplane's loss of engine power. Also causal was the pilot's failure to detect the fuel problem during a preflight inspection.NTSB SEA04LA056Accident · No injuriesLimited investigationFinal reportCessna R182 · Bremerton, WAThe pilot's failure to maintain directional control which resulted in a loss of control and subsequent wing strike with terrain. A contributing factor was the soft terrain.NTSB NYC04CA085Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Bardstown, KYThe pilot's failure to attain the proper touchdown point, and his failure to maintain directional control during landing.NTSB ATL04LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe CFI's inadequate in-flight planning/decision and his inadequate supervision which resulted in fuel exhaustion. A factor was the inadequate preflight planning/preparation to ensure an adequate fuel supply, and the berm.NTSB LAX04LA159Accident · No injuriesLimited investigationFinal reportBeech 65 · Sedona, AZan explosion of the left outboard wing, resulting from a leaking fuel line and the ignition of the flammable fuel/air mixture in the outboard wing bays; the source of ignition energy for the explosion could not be determined. A factor in the accident was an…NTSB LAX04LA149Accident · No injuriesLimited investigationFinal reportCessna 402A · Peach Springs, AZthe pilot's inadequate flare and touchdown that imparted high side loadings on the right main landing gear, which resulted in an overload failure of the landing gear bellcrank and the collapse of that gear.NTSB LAX04FA150Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Oakdale, CAthe in-flight separation of the main spar due to corrosion in the wing center section not detectable by inspection methods described in manufacturer's service bulletins and FAA Airworthiness Directives.NTSB CHI04LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Dubuque, IAThe flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…NTSB DEN04LA051Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Berthoud, COthe pilot's improper flare and his inadequate compensation for wind. The wind gust was a contributing factor.NTSB NYC04LA082Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Frederick, MDTotal loss of engine power for undetermined reasons.NTSB NYC04CA084Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe student pilot's failure to maintain aircraft control while landing. A factor was the student pilot's lack of experience.NTSB FTW04WA093Accident · Minor injuriesForeign investigationCessna 208B · Celaya, MexicoNTSB DEN04LA049Accident · No injuriesLimited investigationFinal reportCessna 182P · Hanksville, UTthe pilot's selection of unsuitable terrain to conduct a precautionary landing. Factors contributing to the accident was the soft, dirt road.NTSB ATL04LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe pilot's improper landing flare and his inadequate recovery from a bounced landing resulting in a hard landing and propeller strike of the runway.NTSB ATL04LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Nashville, TNThe pilot's inadequate compensation for wind and his failure to maintain aircraft control which resulted in a hard landing. The pilot's decision to land in wind conditions that exceeded the demonstrated crosswind component, wind gusts, and a crosswind were…NTSB MIA04LA068Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Labelle, FLThe pilot in command's abrupt pull up, which resulted in an overload of the right wing, right wing separation, an uncontrolled descent, and impact with terrain.NTSB MIA04CA057Accident · No injuriesData collectionFinal reportBeech V35B · Bay St. Louis, MSThe failure of the pilot to complete the landing checklist and extend the landing gear resulting in a gear up landing and damage to the airplane.NTSB LAX04LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, NVthe pilot's premature flare and failure to maintain adequate airspeed resulted in an inadvertent stall and a hard landing, which collapsed the landing gear.NTSB LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.NTSB LAX04CA146Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAthe student pilot's improper use of the cyclic control and the certified flight instructor's inadequate supervision, which resulted in a rollover.NTSB FTW04WA089Accident · 4 fatalForeign investigationCessna 182 · San Luis Potosi, MexicoNTSB FTW04LA088Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · W. Cameron 149A partial loss of engine power due to undetermined reasons. A contributing factor was the emergency floats not being deployed.NTSB DEN04IA050Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Denver, COthe failure of the other flight crew to maintain clearance from the airplane and the ground crews failure to follow proper pushback procedures.