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 CHI96LA149Accident · 1 fatalLimited investigationFinal reportDeweese Bushby Mustang M-II · Lancaster, WIfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin and collison with the terrain. The pilot's use of abrupt maneuvers was a related factor.May 4, 1996 · N16JD · Substantial damageNTSB ANC96LA066Accident · No injuriesLimited investigationFinal reportSwearingen SW-4 · St George, AKfailure of the captain to maintain proper altitude and wingtip clearance, while aligning the airplane with the runway before landing. His delay in aligning the aircraft with the runway was a related factor.May 4, 1996 · N670PA · Substantial damageNTSB SEA96LA087Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Molalla, ORthe pilot's failure to adequately plan the approach, and his misjudgment of distance and speed during the landing. The wet runway was a related factor.May 3, 1996 · N62160 · Substantial damageNTSB NYC96LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Chester, NHThe pilot's misjudged distance and altitude during final approach.May 3, 1996 · N2946P · Substantial damageNTSB IAD96LA070Accident · Serious injuriesLimited investigationFinal reportBellanca BL17-31ATC · Wauseon, OHthe pilot's failure to maintain control of the aircraft which resulted in an inadvertent stall while on short final approach to land.May 3, 1996 · N2CW · DestroyedNTSB FTW96LA201Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-233A · Odessa, TXthe pilot's failure to obtain the required airspeed resulting in a hard landing. A factor was the lack of thermal lift.May 3, 1996 · N7773S · No damageNTSB CHI96LA153Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Layfayette, INthe pilot's improper flare and improper recovery from a bounced landing.May 3, 1996 · N2364N · Substantial damageNTSB ANC96LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKthe pilot's inadequate compensation for the crosswind conditions. Factors associated with the accident were the soft terrain at the landing site, and a crosswind.May 3, 1996 · N70039 · Substantial damageNTSB MIA96LA136Accident · No injuriesLimited investigationFinal reportBeech UC45J · Opa Locka, FLinadequate inspection of the fuel line connector by company maintenance personnel, and failure of a connector resulting in a fuel leak and fire.May 2, 1996 · N64819 · Substantial damageNTSB LAX96TA187Accident · Minor injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain control of the helicopter, while maneuvering close to the ground. The unfavorable wind condition was a related factor.May 2, 1996 · N5184C · DestroyedNTSB FTW96TA195Accident · No injuriesFinal reportRockwell NA-265-80 · Albuquerque, NMoverdeflection of the left outboard main landing gear tire, probably due to underinflation and inadequate inspection, which resulted in fatigue failure of the left outboard tire and subsequent failure of the left inboard tire.May 2, 1996 · N773W · Substantial damageNTSB FTW96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peyton, COthe failure of the right main tire due to valve stem separation.May 2, 1996 · N175WW · Substantial damageNTSB FTW96FA198Accident · No injuriesField investigationFinal reportBeech 1900D · Denver, COfatigue failure of the right main landing gear hydraulic actuator rod at the spherical bearing due to a lack of lubrication.May 2, 1996 · N154ZV · Substantial damageNTSB CHI96LA148Accident · No injuriesLimited investigationFinal reportFairchild M-62C · Garden City, KSfailure of the left main landing gear strut due to corrosoion.May 2, 1996 · N67481 · Substantial damageNTSB CHI96LA147Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Blaine, MNfailure of the pilot to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall/spin.May 2, 1996 · N6059J · Substantial damageNTSB ATL96FAMS1Accident · 3 fatalMissing aircraftFinal reportAero Commander 500-B · MissingUndetermined.May 2, 1996 · N50GV · DestroyedNTSB ANC96LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe student pilot's premature flare and the flight instructor's failure to perform remedial action prior to the hard landing.May 2, 1996 · N3795L · Substantial damageNTSB ANC96LA064Accident · No injuriesLimited investigationFinal reportAviat A-1 · Togiak, AKThe pilot's failure to remove frost from the surface of the wings and his delay in aborting the takeoff. Factors in the accident were the presence of frost on the wings and a deteriorated climb performance.May 2, 1996 · N93HU · Substantial damageNTSB ANC96LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Dillingham, AKfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop/swerve.May 2, 1996 · N9985Y · Substantial damageNTSB ANC96IA065Incident · No injuriesIncident investigationFinal reportVeazie Super Acro Zenith CH · Fairbanks, AKthe pilot's improper understanding of his amended clearance, and the local controller's failure to assure that the pilot understood that he was cleared only to land. Factors in the incident were: the airport design that places two airplanes in close proximity…May 2, 1996 · N200BV · No damageNTSB NYC96LA095Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R200 · Forks Township, PAthe flight instructor's misjudgment of distance and altitude, and delay in performing remedial action.May 1, 1996 · N5030S · Substantial damageNTSB LAX96TA186Accident · No injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain altitude and/or clearance from obstacles, while maneuvering a low altitude at night. Factors relating to the accident were: darkness and the lack of visual cues.May 1, 1996 · N5062Q · Substantial damageNTSB LAX96FA185Accident · Serious injuriesField investigationFinal reportRobinson R22 · Santa Ana, CAthe pilot misjudged the helicopter's distance and altitude and failed to attain the proper descent rate.May 1, 1996 · N9070N · DestroyedNTSB FTW96LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Mountain Home, ARthe pilot's failure to visually check the fuel quantity during the preflight inspection. A factor was the unsuitable terrain for the forced landing.May 1, 1996 · N9869K · Substantial damageNTSB FTW96LA194Accident · No injuriesLimited investigationFinal reportChampion 7AC · Pine Bluff, ARthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.May 1, 1996 · N351T · Substantial damageNTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…May 1, 1996 · N1209C · Substantial damageNTSB ANC96LA067Accident · No injuriesLimited investigationFinal reportCessna 170 · Dillingham, AKrotation (slippage) of the tire on the rim, and shearing of the valve stem, which allowed the rim to contact the ground and then separate.May 1, 1996 · N1828C · Substantial damageNTSB LAX96IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-300-3H4 · Ontario, CAThe repair facility's improper assembly of the landing gear oleo strut during overhaul.Apr 30, 1996 · N331SW · Minor damageNTSB ANC96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Togiak, AKfatigue failure of the right main landing gear strut.Apr 30, 1996 · N2760D · Substantial damageNTSB NYC96FA094Accident · 2 fatalField investigationFinal reportCessna 172RG · Duanesburg, NYfailure of the pilot to attain adequate airspeed (or abort the takeoff while there was sufficient runway remaining), which resulted in a stall after liftoff and collision with the terrain. A factor relating to the accident was: the pilot's distraction due to…Apr 29, 1996 · N9678B · DestroyedNTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…Apr 29, 1996 · N102A · DestroyedNTSB LAX96LA181Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Riverside, CAthe loss of directional control by the pilot's inadequate compensation for the wind gusts, and improper use of the engine and flight controls. The wind was a factor.Apr 29, 1996 · N2182R · Substantial damageNTSB LAX96LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe pilot's misjudged flare, improper bounced landing recovery, and failure to maintain directional control.Apr 29, 1996 · N6596P · Substantial damageNTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…Apr 29, 1996 · N341DA · DestroyedNTSB SEA96LA085Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Covington, WAfuel starvation, due to the pilot's improper fuel management. The uneven terrain in the forced landing area was a related factor.Apr 28, 1996 · N2975T · Substantial damageNTSB NYC96LA093Accident · No injuriesLimited investigationFinal reportCessna 172P · Rutland, VTthe pilot's improper flare and recovery from a bounced landing. A contributing factor was his lack of recent flight experience.Apr 28, 1996 · N98574 · Substantial damageNTSB MIA96LA133Accident · No injuriesLimited investigationFinal reportMooney M20C · Cullowhee, NCThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.Apr 28, 1996 · N5635Q · DestroyedNTSB LAX96LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Mammoth Lakes, CAthe partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…Apr 28, 1996 · N5752X · Substantial damageNTSB FTW96TA186Accident · No injuriesFinal reportCessna T210N · Beaumont, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Apr 28, 1996 · N9403Y · Substantial damageNTSB FTW96LA187Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Carlsbad, NMThe pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the sudden windshift and/or windshear.Apr 28, 1996 · N7256P · Substantial damageNTSB CHI96IA145Incident · Minor injuriesIncident investigationFinal reportBoeing 727-222A · Chicago, ILa passenger disturbance that required the flight attendant to leave her seat. A factor in this accident was the encounter with turbulence as the flight attendant was performing her assigned duties.Apr 28, 1996 · N7443U · No damageNTSB ANC96LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Hope, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was soft terrain.Apr 28, 1996 · N212RF · Substantial damageNTSB ANC96LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKfuel starvation due to a kinked fuel supply line from the left main tank, and the pilot's improper rebuild/remanufacture of the airplane. A smaller than standard fuel line from the fuel strainer to the carburetor, a smaller than standard fuel cap vent, and a…Apr 28, 1996 · N1930A · Substantial damageNTSB ANC96FA059Accident · 1 fatalField investigationFinal reportCessna 150 · Palmer, AKloss of engine power due to a malfunction of the airplane's magneto ignition system, and the pilot's failure to have an annual inspection performed. Factors relating to the accident were: the pilot's lack of recent experience and inadequate in-flight planning…Apr 28, 1996 · N8115U · DestroyedNTSB SEA96LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Erda, UTfailure of the pilot to maintain directional control of the airplane during the landing. Darkness was a related factor.Apr 27, 1996 · N24316 · Substantial damageNTSB MIA96LA135Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Raeford, NCfailure of the passenger to follow the instructions of ground personnel as she exited the aircraft.Apr 27, 1996 · N716NC · No damageNTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.Apr 27, 1996 · N8040 · DestroyedNTSB LAX96LA178Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Diego, CAthe pilot's failure to maintain directional control during landing rollout as a result of his excessive application of brakes and improper use of the elevator (yoke) control.Apr 27, 1996 · N737JE · Substantial damageNTSB IAD96LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culpeper, VAThe pilot's improper compensation for the crosswind.Apr 27, 1996 · N7546G · Substantial damageNTSB IAD96LA068Accident · No injuriesLimited investigationFinal reportBeech B55 · Lynchburg, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve and landing gear collapse. A related factor was the strong crosswind.Apr 27, 1996 · N1580W · Substantial damage