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 NYC91LA179Accident · No injuriesLimited investigationFinal reportRobinson R-22B · White Plains, NYThe failure of the pilot to ensure the helicopter had no lateral motion upon touchdown.Jul 14, 1991 · N2446X · Substantial damageNTSB MIA91LA186Accident · Minor injuriesLimited investigationFinal reportLucky GN-1 Aircamper · Cross City, FLInadequate preflight briefing and inadvertent stall mush during normal cruise flight after encountering turbulence near the destination.Jul 14, 1991 · N99767 · Substantial damageNTSB LAX91LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Mariposa, CAThe pilot misjudging his planned approach. A down-sloping runway surface was a factor in the accident.Jul 14, 1991 · N6521J · Substantial damageNTSB LAX91LA311Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ramona, CAThe pilot-in-command's improper preflight planning preparation and fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion, forced landing and in flight collision with a residence.Jul 14, 1991 · N7893N · Substantial damageNTSB LAX91FA310Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Hesperia, CAThe pilot's improper refueling and inadequate preflight which resulted in fuel contamination and the inadvertent stall.Jul 14, 1991 · N515TW · DestroyedNTSB FTW91LA121Accident · No injuriesLimited investigationFinal reportBell 206B · Freeport, TXThe pilot's failure to maintain sufficient rotor RPM during the autorotation. Factors were the fuel exhaustion induced power loss due to the pilot's improper pre-flight inspection.Jul 14, 1991 · N16962 · Substantial damageNTSB DEN91LA100Accident · Minor injuriesLimited investigationFinal reportAerostar S57-A · Avon, COThe pilot's failure to maintain a visual lookout. A factor was: the pilot's attention being diverted.Jul 14, 1991 · N57053 · Substantial damageNTSB CHI91LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Flint, MIPropeller pitch change mechanism sheared. Factors related to the accident were powerplant vibration and proper touchdown point not possible.Jul 14, 1991 · N8803P · Substantial damageNTSB CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.Jul 14, 1991 · N7616W · DestroyedNTSB BFO91LA073Accident · Minor injuriesLimited investigationFinal reportBeech H50 · Hartwood, VAThe parachutist failure to properly monitor and secure his release handle to protect against accidental parachute deployment.Jul 14, 1991 · N171S · Substantial damageNTSB ATL91LA132Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Social Circle, GAThe airplane collided with the steel pole which supports the windsock while the pilot maneuvered to avoid a collision with a deer on the runway.Jul 14, 1991 · N49964 · Substantial damageNTSB ATL91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, TNA loss of engine power for undetermined reasons.Jul 14, 1991 · N757CB · Substantial damageNTSB ANC91LA099Accident · No injuriesLimited investigationFinal reportCessna 402-C · Kiana, AKThe pilot failed to attain the proper touchdown point and overran the usable portion of the runway which was under construction.Jul 14, 1991 · N67941 · Substantial damageNTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.Jul 13, 1991 · N7458K · Substantial damageNTSB SEA91LA172Accident · No injuriesLimited investigationFinal reportCessna 150H · Shelton, WAInadequate preflight planning/preparation by the pilot in command. Factors to the accident were: delayed go-around gusting winds, poor compensation for wind conditions, and unsuitable terrain.Jul 13, 1991 · N50081 · Substantial damageNTSB SEA91LA168Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Naches, WAThe pilot's poor in-flight decision. Factors include high density altitude, high winds and downdrafts.Jul 13, 1991 · N2184G · DestroyedNTSB SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.Jul 13, 1991 · N6302G · DestroyedNTSB SEA91LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Musselshell, MTThe pilot's intentional stall at low altitude.Jul 13, 1991 · N9792P · DestroyedNTSB NYC91FA178Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Yarmouth, MAThe failure of the number one cylinder fuel injector line due to fatigue cracking induced by corrosion and propagated by cyclic loading which resulted in a total loss of engine power. The corrosion was due to the manufacturer's process of brazing the metal…Jul 13, 1991 · N36272 · DestroyedNTSB MIA91LA185Accident · 1 fatalLimited investigationFinal reportDonald R. Lee AIR Command · Quitman, MSThe pilot in commands failure to maintain control resulting in an uncontrolled descent and an in flight collision with terrain.Jul 13, 1991 · N7165P · DestroyedNTSB LAX91LA309Accident · 2 fatalLimited investigationFinal reportMooney M20 · Little River, CAThe pilot inadvertently inducing a stall spin condition with insufficient altitude to recover from the spin.Jul 13, 1991 · N999LM · DestroyedNTSB LAX91IA308Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAThe failure of the number 2 engine's fire detection system, systron donner fire detector.Jul 13, 1991 · N111AA · No damageNTSB FTW91LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Wilburton, OKThe pilot's decision to abort the take off with insufficient distance remaining. Factors were the fluctuating engine and the trees in his path.Jul 13, 1991 · N45458 · Substantial damageNTSB CHI91LA217Accident · No injuriesLimited investigationFinal reportPiper PA22/20 · Stevens Point, WIThe improper installation of the flight control system rudder control rod (rudder cable bellcrank torque tube) by maintenance personnel. A factor contributing to this accident was the inoperative tailwheel steering.Jul 13, 1991 · N5968D · Substantial damageNTSB CHI91FA208Accident · 1 fatalField investigationFinal reportTemco D-16A · Eau Claire, MIThe improper replacement of the fuel selector lever which resulted in loss of engine power due to fuel staration.Jul 13, 1991 · N88T · Substantial damageNTSB CHI91DTK02Accident · No injuriesFinal reportCessna 188/B · Hecla, SDThe failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.Jul 13, 1991 · N9399G · Substantial damageNTSB ATL91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hazel Green, ALThe inadvertent control interference caused when a parachute line became entangled in the right elevator trim tab, after the student jumper exited the airplane.Jul 13, 1991 · N3742Y · Substantial damageNTSB ANC91LA098Accident · No injuriesLimited investigationFinal reportCessna 185A · Wood River, AKThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft sand in the emergency landing area was a related factor.Jul 13, 1991 · N1689Z · Substantial damageNTSB SEA91LA173Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Toledo, WADirectional control was not maintained.Jul 12, 1991 · N90683 · Substantial damageNTSB MIA91LA184Accident · No injuriesLimited investigationFinal reportCessna 120 · Pocahontas, MSPartial loss of engine power due to undetermined reasons and in-flight collision with a power line during an emergency descent for a forced landing.Jul 12, 1991 · N77411 · Substantial damageNTSB DEN91LA099Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Watkins, COA blown tire and both pilots' failure to maintain directional control.Jul 12, 1991 · N711VL · Substantial damageNTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.Jul 12, 1991 · N31691 · Substantial damageNTSB MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.Jul 11, 1991 · N6891Q · DestroyedNTSB LAX91LA307Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · El Cerrito, CAThe instructor pilot's improper slope takeoff technique.Jul 11, 1991 · N4070H · Substantial damageNTSB LAX91LA306Accident · 1 fatalLimited investigationFinal reportCessna 182 · Wailua, HIThe accidental deployment of jumpers reserve parachute inside the airplane.Jul 11, 1991 · N9022T · Substantial damageNTSB LAX91LA305Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-B · San Jose, CAThe student pilot's failure to unlock the cyclic trim and to maintain his hover altitude. His lack of experience with the aircraft, inadequate preflight, and the uncontrolled descent were factors in the accident.Jul 11, 1991 · N730SH · Substantial damageNTSB FTW91LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Cresson, TXA loss of engine power for unknown reasons and the failure of the certified flight instructor/pilot-in-command to feather the propeller.Jul 11, 1991 · N289RL · DestroyedNTSB FTW91DRA06Accident · 1 fatalFinal reportMorrison-Keitel VOLKSPLANE-1 · Woodbranch, TXThe airplane's collision with trees for undetermined reasons.Jul 11, 1991 · N37898 · DestroyedNTSB CHI91DEM06Accident · 1 fatalFinal reportAeronca 11-AC · Central Lake, MIA result of the pilot in command not maintaining aircraft control and not performing remedial action after the airplane entered the steep descent. A factor contributing to this accident was the pilot in command's lack of recent experience.Jul 11, 1991 · N86083 · DestroyedNTSB NYC91DHM01Accident · Minor injuriesFinal reportAirnew Questair · Lincoln Park, NJA failure of the nose gear fork, which caused the pilot to lose steering control of the airplane and veer off the left side of the runway.Jul 10, 1991 · N75A · Substantial damageNTSB LAX91LA304Accident · 1 fatalLimited investigationFinal reportPiper PA24-250 · Temple Bar, AZThe pilot's failure to maintain control of the aircraft during an attempted return to runway maneuver and the entry into an inadvertent stall/spin at low altitude. The exact nature of the emergency problem encountered by the pilot is undetermined.Jul 10, 1991 · N8142P · DestroyedNTSB LAX91LA303Accident · 1 fatalLimited investigationFinal reportE.C Trynka Pietenpol Aircamper · Skull Valley, AZThe pilot inadvertently inducing a stall spin condition with insufficient altitude to recover from the spin.Jul 10, 1991 · N64661 · DestroyedNTSB LAX91LA302Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAThe erection of a construction sign on an active runway by county workers without notifying the airport operators, and, the inability of the pilot to detect the presence of the sign during the dark night takeoff.Jul 10, 1991 · N4538K · DestroyedNTSB DCA91MA042Accident · 13 fatalMajor investigationFinal reportBeech C99 · Birmingham, ALThe decision of the captain to initiate and continue an instrument approach into clearly identified thunderstorm activity, resulting in a loss of control of the airplane from which the flightcrew was unable to recover and subsequent collision with obstacles…Jul 10, 1991 · N7217L · DestroyedNTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.Jul 10, 1991 · N4905Q · Substantial damageNTSB ANC91FA094Accident · 1 fatalField investigationFinal reportCessna U206C · Nikiski, AKPoor judgement of the pilot, due to impairment from consumption of alcohol, and his failure to maintain adequate airspeed, while maneuvering during an aborted landing (go-around). Factors related to the accident were: the open cargo door, disabled flaps, and…Jul 10, 1991 · N3941G · DestroyedNTSB SEA91LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Medford, ORAn intentional porpoise. Factors include the pilot's psychological condition.Jul 9, 1991 · N734MD · Substantial damageNTSB NYC91LA177Accident · No injuriesLimited investigationFinal reportCessna L-19 · Franconia, NHThe failure of the pilot to maintain airspeed, which resulted in a stall/spin and in flight collision with trees. Factors related to the accident were the improper in-flight planning by the pilot and the pilot's failure to compensate for winds and downdraft.Jul 9, 1991 · N5237G · DestroyedNTSB NYC91LA176Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Stebensville, PAThe pilot's failure to refuel the airplane, his improper fuel consumption calculations, and his failure to flare the airplane during the forced landing.Jul 9, 1991 · N32126 · Substantial damageNTSB MIA91LA229Accident · No injuriesLimited investigationFinal reportBell 206B · Vero Beach, FLThe pilot-in-command's failure to maintain the proper descent rate resulting in a hard landing.Jul 9, 1991 · N333FC · Substantial damage