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 MIA92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceville, GAThe separation of numbers 1,2, and 3 connecting rods for undetermined reasons resulting in loss of engine power.NTSB LAX92FA064Accident · 1 fatalField investigationFinal reportGlasair SH-2R · Nuevo, CAThe failure of the pilot to perform preventative maintenance on the airplane's powerplant which resulted in a loss of performance during an unknown phase of operation. Contributing to the accident was fouled spark plugs and the partial loss of aircraft…NTSB FTW92LA038Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKClearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.NTSB DEN92IA014Incident · No injuriesIncident investigationFinal reportCessna 172RG · Broomfield, COFailure of the left main landing gear pivot assembly due to ductile torsional overstress.NTSB CHI92LA047Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mt Pleasant, MIWater in the fuel, and an inadequate preflight by the pilot.NTSB CHI92LA046Accident · No injuriesLimited investigationFinal reportCessna 421 · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing. A factor contributing to the accident was the icy runway.NTSB CHI92LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · Morris, MNFailure to maintain proper glidepath. A factor related to the accident is the failure to perform remedial action, the dark night, and the snow shower in progress at the time.NTSB NYC92LA039Accident · No injuriesLimited investigationFinal reportCessna 182 · Westerly, RIThe failure of the pilot to remove all the water from the fuel system prior to takeoff which resulted in a power loss.NTSB CHI92FA037Accident · No injuriesField investigationFinal reportBeech G-18S · West Chicago, ILA result of the pilot in command's not maintaining directional control, an improper inflight decision, and improper remedial action once the loss of directional control was recognized by the pilot. Factors contributing to this accident are inadequate cargo…NTSB ATL92LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Ramseur, NCThe pilot's improper compensation for the wind conditions. The gusty crosswind was a factor in the accident.NTSB CHI92LA041Accident · No injuriesLimited investigationFinal reportCessna 210N · Frankfort, ILThe failure of the fss to notify ATC that the ariport was closed, atc's subsequent approach clearance to the closed airport, and the pilot's inability to maintain directional control on the icy runway. A factor in the accident was the icy runway conditions.NTSB CHI92LA038Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Iowa, IAThe pilot's failure to extend the landing gear which resulted in the propeller blades contacting the runway during the landing. A factor related to the accident was the pilot's failure to follow a checklist during the approach.NTSB SEA92LA025Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AC · Missoula, MTThe pilot's inability to maintain directional control during takeoff. Factors include a dragging brake.NTSB FTW92LA044Accident · No injuriesLimited investigationFinal reportHiller-Osborn UH-12D · Rio Medina, TXThe pilot's improper flare during touchdown.NTSB FTW92LA032Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Hamilton, TXThe inadvertend encounter with icing conditions. Factors were the unavailability of an airport weather observation facility and the deteriorated aircraft performance.NTSB DEN92LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Siebert, COTotal loss of engine power due to a plugged vent in the tank filler cap, resulting in fuel starvation. Factors related to the accident were: darkness and the lack of suitable terrain for a forced landing.NTSB LAX92LA056Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Palo Alto, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB FTW92LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Lubbock, TXThe in flight collision with geese. A factor was the dark night.NTSB FTW92LA031Accident · No injuriesLimited investigationFinal reportCessna 210 · Groves, TXFuel exhaustion which precipitated the forced landing due to the pilot's inadequate fuel consumption calculations. A factor in the accident was the pilot's failure to divert to an alternate destination when he recognized that fuel exhaustion was a possibility.NTSB DEN92IA013Incident · No injuriesIncident investigationFinal reportCessna T210M · La Veta, COFailure of the no 1 connecting rod due to lack of lubrication from blocked oil ports.NTSB CHI92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, MOContinued flight by the pilot into known icing conditions, and his improper planning/decision, which resulted in an overrun of the runway after he diverted to an alternate airport. The adverse weather condition, icy runway, and chain link fence near the end…NTSB CHI92LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-200 · Lakeville, MNThe failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.NTSB BFO92FA011Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Sandston, VAThe loss of engine power due to fuel exhaustion and the pilots selection of unsuitable terrain for the force landing. A factor was the pilot's improper inflight decision.NTSB ANC92LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKThe certified flight instructor's (CFI) delay in initiating the go around. Contributing to the accident was the snow berm and dark night light condition.NTSB SEA92FA024Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Everett, WAFuel starvation due to improper procedures by the pilot-in-command. Factors include lack of familiarity with the aircraft, non-functioning flight compartment lights, and non-suitable terrain.NTSB MIA92LA036Accident · No injuriesLimited investigationFinal reportCessna 210M · Zephyrhills, FLImproper placement of the fuel selector by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. Contributing to the accident was an incorrect fuel quantity gage, the dark night condition, and unsuitable terrain encountered.NTSB LAX92LA055Accident · No injuriesLimited investigationFinal reportCessna 421B · San Andreas, CAThe pilot's inadequate preflight inspection and his failure to follow the airplane's checklist. A contributing factor was the dark night condition.NTSB FTW92LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Morse, TXThe pilot's attempted VFR flight into IMC conditions. Factors were, the pilot's lack of instrument qualification, his failure to obtain a weather briefing prior to the flight, and dark night conditions.NTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.NTSB FTW92FA029Accident · Serious injuriesField investigationFinal reportCessna 402B · Roanoke, TXThe operation of the airplane with known deficiencies, a missing air cooling baffle, and inadequate maintenance. Factors were the frozen propeller, inability of the pilot to feather the propeller, inoperative landing gear, the inability of the pilot to…NTSB DEN92LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Denver, COA false unsafe landing gear indication due to a frozen down lock switch. Factors were: icing conditions and low ceilings.NTSB CHI92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Willmar, MNAn inadequate weather evaluation which resulted in flight into icing conditions. Factors in the accident were the icing conditions and the excessive descent during landing.NTSB NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.NTSB NYC92LA037Accident · Minor injuriesLimited investigationFinal reportConvair CV-240 · Akron, OHThe use of an improper grade of fuel, which was approved by the captain and resulted in a loss of engine power duirng climbout and an in flight collision with terrain.NTSB LAX92FA054Accident · 4 fatalField investigationFinal reportAerospatiale SA 316B · Bridgeport, CAFailure of the helicopter's tail rotor drive shaft and drive shaft bearing due to undetermined reason(s).NTSB ATL92LA027Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Statesville, NCLoss of engine power for undetermined reasons. A factor was the lack of a suitable landing site.NTSB MIA92LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bunnell, FLImproper handling of the aircraft by the pilot-in-command and failure to maintain directional control. Contributing to the accident was the lack of total experience of the pilot-in-command.NTSB LAX92LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAThe failure of the pilot to maintain directional control during the landing touchdown.NTSB FTW92LA027Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Fe, NMThe right main gear collapsed for undetermined reasons, which resulted in the pilot's loss of directional control during the landing roll.NTSB DEN92LA010Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Watkins, COFailure to maintain directional control of the airplane during landing flare. A factor was the crosswind condition that existed at the time of the accident.NTSB CHI92LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Decorah, IAInadequate compensation for wind conditions, which resulted in a loss of directional control. Factors related to the accident were: the unfavorable wind conditions, snow covered runway, and snowbanks adjacent to the runway.NTSB CHI92FA035Accident · 4 fatalField investigationFinal reportCessna 172RG · Litchfield, MNPilot factor in that he had spatial disorientation. Factors related to the accident are; VFR flight into IMC, disregarding hazardous weather advisories, performing flight into known adverse weather conditions, and overconfidence in personal ability by the…NTSB MIA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe pilot-in-command's improper use of the rudder controls and brakes. A contributing factor was his lack of total experience.NTSB LAX92LA059Accident · No injuriesLimited investigationFinal reportCessna 182H · Tucson, AZFuel exhaustion due to the pilot's inadequate preflight inspection, her failure to ensure that an adequate fuel supply was onboard and her decision not to refuel the aircraft prior to departure. Factors in the accident were: 1) the inoperative left fuel gage;…NTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB FTW92GA036Accident · No injuriesFinal reportBeech C-12C · Belen, NMThe pilot's failure to land at the proper touchdown point.NTSB MIA92WA037Accident · No injuriesForeign investigationBell-Transworld 47G2 · David, PanamaNTSB FTW92LA034Accident · No injuriesLimited investigationFinal reportCessna 172P · Okmulgee, OKThe pilot's failure to compensate for a crosswind condition. Factors were the pilot's lack of total experience and the prevailing crosswind.NTSB ATL92FA026Accident · Minor injuriesField investigationFinal reportCessna 210H · Carrollton, GAThe contamination of the aircraft fuel system with ice and water, which was undetectable by the pilot.NTSB NYC92LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1040 · Portland, METhe excessive fuel pressure during inflight fuel transferring, which resulted in the rupture of the wing tank and subsequent damage to the wing. Also causal to the accident was the inadequate fuel tank vent system and the inaccurate fuel quantity system.