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.

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.Dec 6, 1991 · N7411J · DestroyedNTSB 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…Dec 6, 1991 · N614LS · DestroyedNTSB 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.Dec 5, 1991 · N6947X · Substantial damageNTSB DEN92IA014Incident · No injuriesIncident investigationFinal reportCessna 172RG · Broomfield, COFailure of the left main landing gear pivot assembly due to ductile torsional overstress.Dec 5, 1991 · N9320D · Minor damageNTSB CHI92LA047Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mt Pleasant, MIWater in the fuel, and an inadequate preflight by the pilot.Dec 5, 1991 · N6930C · Substantial damageNTSB 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.Dec 5, 1991 · N777RA · Substantial damageNTSB 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.Dec 5, 1991 · N201QB · Substantial damageNTSB 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.Dec 4, 1991 · N92181 · Substantial damageNTSB 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…Dec 4, 1991 · N38RM · DestroyedNTSB 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.Dec 4, 1991 · N65013 · DestroyedNTSB 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.Dec 3, 1991 · N5281A · Substantial damageNTSB 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.Dec 3, 1991 · N14TP · Substantial damageNTSB SEA92LA025Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AC · Missoula, MTThe pilot's inability to maintain directional control during takeoff. Factors include a dragging brake.Dec 2, 1991 · N26932 · Substantial damageNTSB FTW92LA044Accident · No injuriesLimited investigationFinal reportHiller-Osborn UH-12D · Rio Medina, TXThe pilot's improper flare during touchdown.Dec 2, 1991 · N67065 · Substantial damageNTSB 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.Dec 2, 1991 · N6890T · Substantial damageNTSB 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.Dec 2, 1991 · N3745A · Substantial damageNTSB LAX92LA056Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Palo Alto, CAThe pilot's failure to maintain directional control during the landing rollout.Dec 1, 1991 · N3170Z · Substantial damageNTSB FTW92LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Lubbock, TXThe in flight collision with geese. A factor was the dark night.Dec 1, 1991 · N73SW · Substantial damageNTSB 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.Dec 1, 1991 · N9503T · Substantial damageNTSB DEN92IA013Incident · No injuriesIncident investigationFinal reportCessna T210M · La Veta, COFailure of the no 1 connecting rod due to lack of lubrication from blocked oil ports.Dec 1, 1991 · N6179N · Minor damageNTSB 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…Dec 1, 1991 · N9533W · Substantial damageNTSB 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.Dec 1, 1991 · N2072T · 2 aircraft · Substantial damageNTSB 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.Dec 1, 1991 · N5174P · DestroyedNTSB 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.Dec 1, 1991 · N704YP · Substantial damageNTSB 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.Nov 30, 1991 · CFKTQ · Substantial damageNTSB 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.Nov 30, 1991 · N9064M · Substantial damageNTSB 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.Nov 29, 1991 · N421DP · Substantial damageNTSB 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.Nov 29, 1991 · N37749 · Substantial damageNTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.Nov 29, 1991 · N1906N · Substantial damageNTSB 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…Nov 29, 1991 · N69CR · DestroyedNTSB 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.Nov 29, 1991 · N354AC · Substantial damageNTSB 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.Nov 29, 1991 · N80553 · Substantial damageNTSB 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.Nov 28, 1991 · N25262 · Substantial damageNTSB 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.Nov 28, 1991 · N450GA · DestroyedNTSB 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).Nov 28, 1991 · N146RM · DestroyedNTSB 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.Nov 28, 1991 · N35535 · Substantial damageNTSB 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.Nov 27, 1991 · N152ER · Substantial damageNTSB LAX92LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAThe failure of the pilot to maintain directional control during the landing touchdown.Nov 27, 1991 · N2982A · Substantial damageNTSB 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.Nov 27, 1991 · N2645C · Substantial damageNTSB 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.Nov 27, 1991 · N41698 · Substantial damageNTSB 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.Nov 27, 1991 · N44061 · Substantial damageNTSB 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…Nov 27, 1991 · N9589B · DestroyedNTSB 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.Nov 26, 1991 · N68967 · Substantial damageNTSB 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;…Nov 26, 1991 · N1986X · Substantial damageNTSB 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.Nov 26, 1991 · N733PB · DestroyedNTSB FTW92GA036Accident · No injuriesFinal reportBeech C-12C · Belen, NMThe pilot's failure to land at the proper touchdown point.Nov 26, 1991 · N783MC · Substantial damageNTSB MIA92WA037Accident · No injuriesForeign investigationBell-Transworld 47G2 · David, PanamaNov 25, 1991 · N64589 · Substantial damageNTSB 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.Nov 25, 1991 · N65748 · Substantial damageNTSB ATL92FA026Accident · Minor injuriesField investigationFinal reportCessna 210H · Carrollton, GAThe contamination of the aircraft fuel system with ice and water, which was undetectable by the pilot.Nov 25, 1991 · N65SD · Substantial damageNTSB 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.Nov 24, 1991 · N24894 · Substantial damage