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 ANC96LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature lift-off during the takeoff roll. The pilot's selection of unsuitable terrain for takeoff was a factor in the accident.Jun 16, 1996 · N8796D · Substantial damageNTSB SEA96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hillsboro, ORthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point for landing. A factor relating to the accident was: upsloping terrain short of the threshold.Jun 15, 1996 · N6554P · Substantial damageNTSB SEA96GA129Accident · Minor injuriesFinal reportCessna 182R · Grand View, IDfailure of the pilot to maintain clearance from mountainous terrain in a box canyon. The mountainous terrain and box canyon, limiting the pilot's ability to climb or maneuver and maintain sufficient altitude in the canyon, were related factors.Jun 15, 1996 · N6356N · Substantial damageNTSB NYC96LA128Accident · No injuriesLimited investigationFinal reportCessna 180 · Fulton, NYThe pilot's inadequate compensation for wind conditions.Jun 15, 1996 · N7783A · Substantial damageNTSB LAX96LA233Accident · 1 fatalLimited investigationFinal reportVan Horn Velocity · Goodyear, AZan engine compartment fire, which originated in flight from loose fuel and/or oil lines near the engine's firewall.Jun 15, 1996 · N444BG · DestroyedNTSB IAD96LA096Accident · Minor injuriesLimited investigationFinal reportLittle Scamp · Worthington, KYwas the loss of engine power for undetermined reasons shortly after liftoff. A related factor was the unsuitable terrain encountered during the forced landing.Jun 15, 1996 · N9995A · DestroyedNTSB FTW96LA254Accident · No injuriesLimited investigationFinal reportCessna 172H · Crockett, TXLoss of engine power for undetermined reason(s).Jun 15, 1996 · N8824Z · Substantial damageNTSB FTW96LA251Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, ARThe partial loss of engine power due to fuel contamination. A factor was the lack of suitable terrain available for the forced landing.Jun 15, 1996 · N1004W · Substantial damageNTSB FTW96LA249Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · Tulsa, OKthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Darkness was a related factor.Jun 15, 1996 · N115JE · Substantial damageNTSB FTW96FA250Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Monument, COThe pilot's VFR flight into instrument meteorological conditions in an aircraft which not instrument-equipped. Factors were clouds, low ceiling, and rain.Jun 15, 1996 · N111BF · DestroyedNTSB CHI96WA204Accident · 1 fatalForeign investigationPiper PA-24-250 · Pelican Narrows, CanadaJun 15, 1996 · N6541P · DestroyedNTSB CHI96LA205Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Lambertville, MIa total loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight, and the pilot's misjudged distance/altitude during the subsequent autorotation. A factor was inadequate maintenance and inspection.Jun 15, 1996 · N557H · Substantial damageNTSB CHI96LA203Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Oslo, MNthe pilot not using carburetor heat when the engine began to lose power. Factors in this accident were carburetor ice formation and the soft landing surface the pilot had to use for landing.Jun 15, 1996 · N36311 · Substantial damageNTSB ATL96LA092Accident · No injuriesLimited investigationFinal reportCessna 411 · Rome, GAthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power in both engines, due to an inadequate supply of fuel.Jun 15, 1996 · N3203R · Substantial damageNTSB ANC96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKA loss of engine power due to low fuel pressure from the engine driven fuel pump and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.Jun 15, 1996 · N8956N · Substantial damageNTSB SEA96LA127Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Aurora, ORinadvertent retraction of the landing gear by the pilot during landing.Jun 14, 1996 · N67SA · Substantial damageNTSB NYC96LA130Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Elbridge, NYThe pilot's improper decision to use auto fuel and to fly the airplane when it was in need of major repairs and overdue its annual inspection.Jun 14, 1996 · N8073K · Substantial damageNTSB NYC96FA126Accident · 3 fatalField investigationFinal reportPiper PA-23-150 · Cortland, NYthe pilot failure to maintain directional control of the airplane which resulted in the airplane striking trees. Contributing factors were the pilot's spatial disorientation, dark night conditions, fog, and the pilot's self induced pressure to reach the…Jun 14, 1996 · N2189P · DestroyedNTSB LAX96LA245Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NVthe pilot's inadvertent turn onto a vehicular access road instead of a taxiway at a large unfamiliar airport, and his diverted attention.Jun 14, 1996 · N6420P · Substantial damageNTSB LAX96LA231Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Inyokern, CAthe pilot's failure to maintain control of his airplane and stalled while intentionally performing a low altitude maneuver on base leg in a high density altitude environment.Jun 14, 1996 · N43BL · DestroyedNTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…Jun 14, 1996 · N4006K · DestroyedNTSB IAD96LA095Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Versailles, OHFuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.Jun 14, 1996 · N3197T · Substantial damageNTSB FTW96LA256Accident · No injuriesLimited investigationFinal reportCessna R172K · Watkins, COan improper flare by the pilot, which resulted in a hard landing.Jun 14, 1996 · N3814V · Substantial damageNTSB CHI96LA206Accident · Serious injuriesLimited investigationFinal reportMitchell T Champabria · Kalamazoo, MIthe pilot's improper positioning of the throttle, while hand propping the aircraft engine, and his failure to either obtain proper assistance or properly secure the airplane.Jun 14, 1996 · N96RM · Substantial damageNTSB CHI96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Grand Forks, NDthe instructor pilot used an improper procedure when he demonstrated a rejected takeoff and he misjudged the flare.Jun 14, 1996 · N853ND · Substantial damageNTSB CHI96IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320 · Boston, MAan undetermined intermittent fault in the trimmable horizontal stabilizer actuator system.Jun 14, 1996 · N347NW · No damageNTSB CHI96IA200Incident · No injuriesIncident investigationFinal reportBoeing 727-30C · Chicago, ILlow pressure in the fuel lines caused when the crossfeed valve was closed and the boost pumps to the effected fuel tank were turned off, a fuel pressure surge (spike) accompanied by a rapid drop in high pressure pump output and burner line pressures, when…Jun 14, 1996 · N906UP · No damageNTSB ATL96FA094Accident · 1 fatalField investigationFinal reportCessna 172N · Arlington, TNThe pilot's failure to maintain clearance above the trees. A factor was the dark night.Jun 14, 1996 · N73941 · Substantial damageNTSB NYC96LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Gardner, MAthe pilot 's misjudgment of speed and distance during landing.Jun 13, 1996 · N7373G · Substantial damageNTSB NYC96FA125Accident · 3 fatalField investigationFinal reportBeech V35 · Williamstown, NJinadequate supervision by the flight instructor (CFI); and failure of the pilot rated (dual) student to maintain control of the airplane during a simulated forced landing after takeoff, which resulted in a stall and collision with the terrain. Factors…Jun 13, 1996 · N2011W · DestroyedNTSB LAX96FA229Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Big Bear City, CAimproper preflight by the pilot, by failing to ensure that the fuel selector was positioned to an approved fuel tank with adequate fuel before takeoff; his failure to reposition the fuel selector (per emergency procedures) after the loss of engine power; and…Jun 13, 1996 · N7280P · DestroyedNTSB FTW96LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Levelland, TXThe student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.Jun 13, 1996 · N17299 · Substantial damageNTSB CHI96LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Charlotte, MIthe pilot's inadequate preflight planning and failure to use all the available runway for takeoff. Factors associated with the accident were the wet grass airstrip and the powerlines.Jun 13, 1996 · N16047 · Substantial damageNTSB NYC96LA127Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Fulton, NYthe student pilot's improper flare and the flight instructor's inadequate supervision.Jun 12, 1996 · N5981X · Substantial damageNTSB LAX96LA246Accident · No injuriesLimited investigationFinal reportCessna 172M · Sedona, AZthe pilot's improper recovery from a bounced landing. The variable/gusty/quartering tail wind was a related factor.Jun 12, 1996 · N12341 · Substantial damageNTSB LAX96LA225Accident · No injuriesLimited investigationFinal reportCessna 150H · Angels Camp, CAThe attempt by the pilot to operate the aircraft with a float known to be leaking. A factor was the pilot's lack of experience in the operation of float equipped aircraft.Jun 12, 1996 · N22474 · Substantial damageNTSB LAX96LA220Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Placerville, CAthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.Jun 12, 1996 · N7880F · DestroyedNTSB FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.Jun 12, 1996 · N3535E · Substantial damageNTSB CHI96LA198Accident · No injuriesLimited investigationFinal reportPiper J-3 · Princeton, MNLoss of engine power for an undetermined reason.Jun 12, 1996 · N35505 · Substantial damageNTSB ATL96LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Gulfport, MSimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.Jun 12, 1996 · N39018 · Substantial damageNTSB SEA96LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Bountiful, UTinadequate fuel management by the student pilot, which resulted in fuel starvation, due to an improperly positioned fuel selector. Factors relating to the accident were: the pilot's inadequate remedial action, and a ditch in the emergency landing area.Jun 11, 1996 · N5172W · Substantial damageNTSB FTW96LA245Accident · No injuriesLimited investigationFinal reportBeech 23 · Weiner, ARan improper flare by the pilot, which resulted in a hard landing.Jun 11, 1996 · N2398L · Substantial damageNTSB FTW96IA248Incident · No injuriesIncident investigationFinal reportFairchild SA227-DC · Enid, OKfailure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.Jun 11, 1996 · N850LS · No damageNTSB CHI96LA218Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waterville, KSthe pilot's inadequate preflight procedure. Factors were fuel exhaustion, a leak in the fuel filtering system, and high vegetation.Jun 11, 1996 · N7289Z · Substantial damageNTSB CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.Jun 11, 1996 · N9844P · DestroyedNTSB CHI96LA193Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lowell, MIwas inadequate initial training of the pilot and inadequate flight test procedures by the FAA Designated Pilot Examiner when he reportedly had the pilot demonstrate 12 pilot operations from the FAA's practical flight test standards in 35 minutes during the…Jun 11, 1996 · N1106F · Substantial damageNTSB ANC96TA087Accident · No injuriesFinal reportCessna 185F · Gustavus, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.Jun 11, 1996 · N56581 · Substantial damageNTSB SEA96LA128Accident · 1 fatalLimited investigationFinal reportBailey Antares MA30 · Woodland, WAfailure of the uncertificated pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain. The pilot's abrupt pull-up was a related factor.Jun 10, 1996 · UNREG · Substantial damageNTSB SEA96LA121Accident · No injuriesLimited investigationFinal reportBeech 35 · Aurora, ORfailure of the non-certificated pilot to ensure that the landing gear was properly extended for landing. The non-certificated pilot's diverted attention was a related factor.Jun 10, 1996 · N2145D · Substantial damageNTSB NYC96FA123Accident · 2 fatalField investigationFinal reportBeech E90 · Woolwich, MEfailure of the pilot to maintain control of the airplane while climbing after takeoff, due to spatial disorientation, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors relating to the accident were: the improper…Jun 10, 1996 · N916PA · Destroyed