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 ATL97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Winston Salem, NCthe pilot's inadequate compensation for wind conditions and failure to maintain directional cntrol of the airplane, which resulted in a ground swerve and collapse of the right main landing gear. The crosswind was a related factor.Feb 12, 1997 · N15013 · Substantial damageNTSB MIA97WA100Accident · 1 fatalForeign investigationCessna T210 · Challao, ArgentinaFeb 11, 1997 · N470E · DestroyedNTSB LAX97LA102Accident · No injuriesLimited investigationFinal reportGreen Cozy III · San Martin, CAA loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.Feb 11, 1997 · N34PC · Substantial damageNTSB LAX97FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-161 · Avalon, CAundetermined.Feb 11, 1997 · N8436X · DestroyedNTSB FTW97LA102Accident · Serious injuriesLimited investigationFinal reportCessna 210-5 · Hobbs, NMThe loss of engine power due to fuel starvation for undetermined reasons. A factor was the pilot's continued flight after a fuel consumption anomaly was encountered.Feb 11, 1997 · N1866Z · Substantial damageNTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.Feb 10, 1997 · N115WL · Substantial damageNTSB NYC97LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-44-180T · Caldwell, NJThe pilot's incapacitation due to a heart attack.Feb 9, 1997 · N8457H · No damageNTSB LAX97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Madera, CAThe pilot's failure to maintain adequate clearance from obstructions and his inadequate visual outlook.Feb 9, 1997 · N1900F · DestroyedNTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.Feb 9, 1997 · N6679F · Substantial damageNTSB MIA97FA082Accident · 2 fatalField investigationFinal reportCessna 402C · St. ThomasThe failure of the pilot to maintain altitude while making a visual approach at night over water in black hole conditions resulting in the aircraft descending and crashing into the sea. Contributing to the accident was the failure of the pilot and operator to…Feb 8, 1997 · N318AB · DestroyedNTSB LAX97LA101Accident · No injuriesLimited investigationFinal reportCessna 210H · Big Bear City, CAa corroded landing gear down limit switch, which resulted in a retracted left main gear during the landing sequence.Feb 8, 1997 · N6137F · Substantial damageNTSB LAX97LA099Accident · No injuriesLimited investigationFinal reportAyres S2R-T65 · Firebaugh, CAfailure of the pilot to compensate for crosswind conditions and to maintain proper runway alignment. Factors relating to the accident were: the crosswind, narrow runway condition, and the soft terrain and ditch beside the runway.Feb 8, 1997 · N3101K · Substantial damageNTSB LAX97LA097Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Los Angeles, CAFuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.Feb 8, 1997 · N10ML · Substantial damageNTSB DCA97WA025Accident · No injuriesForeign investigationBoeing B-737-300 · Nurnberg/Gerf, GermanyFeb 8, 1997 · DHTSW · No damageNTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.Feb 8, 1997 · N13611 · Substantial damageNTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…Feb 7, 1997 · N5618J · Substantial damageNTSB MIA97LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Homosassa, FLthe unqualified person's poor judgment, by taking the helicopter without the owner's permission and attempting an unauthorized flight at night; and his failure (or inability) to maintain control the helicopter. Darkness was a related factor.Feb 7, 1997 · N9061R · Substantial damageNTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.Feb 7, 1997 · N714EE · DestroyedNTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.Feb 7, 1997 · N93873 · Substantial damageNTSB ANC97FA026Accident · 1 fatalField investigationFinal reportPiper PA-18 · Circle, AKinadequate preflight by the pilot; and his subsequent loss of aircraft control, during the initial climb after takeoff. Factors relating to the accident were: the pilot failed to ensure that the cargo was properly secured, and he allowed the aircraft's weight…Feb 7, 1997 · N121BB · DestroyedNTSB SEA97LA058Accident · No injuriesLimited investigationFinal reportCessna 421C · Cedar City, UTwater contamination in the hydraulic system, which froze in the (right) main gear hydraulic actuator, and restricted movement of the (right) main gear retraction and extension system.Feb 6, 1997 · N45MV · Substantial damageNTSB DCA97LA027Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600R · St John Antigua, Antigua & BarbudaThe captain failed to establish and maintain a stabilized approach (or perform a go-around), and applied excessive pitch rotation during the subsequent recovery from a bounced landing, resulting in a tail strike. A factor contributing to the accident was the…Feb 6, 1997 · N41063 · Substantial damageNTSB ATL97LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLA loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.Feb 6, 1997 · N67544 · Substantial damageNTSB FTW97RA101Accident · 1 fatalForeign investigationBeech 23 · Santa Catarina, MexicoFeb 5, 1997 · N8723MNTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.Feb 4, 1997 · N62332 · Substantial damageNTSB FTW97FA100Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Lone Wolf, OKthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, and his failure to maintain sufficient altitude (clearance above a lake), while performing aerobatic flight. Factors relating to the accident were: the…Feb 3, 1997 · N33322 · DestroyedNTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.Feb 3, 1997 · N31794 · Substantial damageNTSB ATL97LA038Accident · No injuriesLimited investigationFinal reportBeech 23 · Palatka, FLfailure of the nose gear for undetermined reason(s).Feb 3, 1997 · N2379L · Substantial damageNTSB SEA97LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Moorcroft, WYThe pilot's failure to maintain adequate airspeed. A factor was the pilot's low altitude flight and maneuvering.Feb 2, 1997 · N83347 · Substantial damageNTSB SEA97LA055Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bandon, ORthe dual student's failure to maintain directional control of the airplane, and the flight instructor's improper remedial action. A factor relating to the accident was: the ravine located near the right side of the runway.Feb 2, 1997 · N11099 · Substantial damageNTSB NYC97LA052Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cincinnati, OHThe flight instructor's inadequate supervision and delayed remedial reaction which resulted in the loss of directional control by the student pilot during the landing roll out.Feb 2, 1997 · N30598 · Substantial damageNTSB NYC97LA050Accident · No injuriesLimited investigationFinal reportBerry Vans RV-4 · York, PAthe pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.Feb 2, 1997 · N42BN · Substantial damageNTSB MIA97LA081Accident · Serious injuriesLimited investigationFinal reportCessna A150L · St. Mary'S, GAthe pilot's failure to maintain airspeed which resulted in an inadvertent stall the at too low an altitude to allow recovery. A factor in this accident was the pilot's attention was diverted.Feb 2, 1997 · N6005J · Substantial damageNTSB LAX97LA096Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Payson, AZa loss of engine power for undetermined reasons.Feb 2, 1997 · N61DE · Substantial damageNTSB CHI97LA063Accident · No injuriesLimited investigationFinal reportBeech B200 · Marshall, MNthe pilot inadvertently putting the gear selector switch in the up position during landing.Feb 2, 1997 · N66404 · Substantial damageNTSB MIA97WA089Accident · Minor injuriesForeign investigationPiper PA-18 · Valparaiso, ChileFeb 1, 1997 · N2414P · Substantial damageNTSB MIA97LA080Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sarasota, FLthe pilot's failure to maintain clearance from obstacles.Feb 1, 1997 · N64TD · Substantial damageNTSB MIA97LA079Accident · No injuriesLimited investigationFinal reportBeech V35 · Orlando, FLloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.Feb 1, 1997 · N599T · Substantial damageNTSB MIA97LA078Accident · No injuriesLimited investigationFinal reportRichards Velocity 173 RG · Valkaria, FLa loss of engine power for undetermined reasons.Feb 1, 1997 · N525V · Substantial damageNTSB MIA97LA077Accident · 1 fatalLimited investigationFinal reportBeech 95-B55 · Monroe, NCpilot incapacitation as result of Ischemic heart disease.Feb 1, 1997 · N70F · Substantial damageNTSB FTW97LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Waxahachie, TXThe loss of engine power for undetermined reasons. A factors was the lack of suitable terrain for the forced landing.Feb 1, 1997 · N5598T · DestroyedNTSB DCA97WA023Accident · Serious injuriesForeign investigationBoeing DC-10-30 · Fort du France, WNFeb 1, 1997 · F-GPVA · No damageNTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.Feb 1, 1997 · N4655X · Substantial damageNTSB CHI97LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INthe pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.Feb 1, 1997 · N4696G · Substantial damageNTSB CHI97LA061Accident · No injuriesLimited investigationFinal reportCessna 182K · El Dorado, KSthe pilot's failure to maintain directional control of the airplane. A factor relating to the accident was: the ditch, which the airplane contacted.Feb 1, 1997 · N2898R · Substantial damageNTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.Feb 1, 1997 · N50TB · DestroyedNTSB ANC97LA025Accident · 3 fatalLimited investigationFinal reportPiper PA-22 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent failure to maintain control of the airplane. Factors associated with the accident are the pilot's inadequate weather evaluation, his becoming lost/disoriented, and…Feb 1, 1997 · N7235D · DestroyedNTSB LAX97LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Scottsdale, AZfuel exhaustion due to the pilot's improper fuel management.Jan 31, 1997 · N6638V · Substantial damageNTSB FTW97FA097Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKThe flight instructor's failure to obtain/maintain clearance with the power line. A factor was the sunglare from the setting sun, which could have impaired the flight instructor's ability to see the power line.Jan 31, 1997 · N5366B · DestroyedNTSB ATL97LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Wiggins, MSthe student pilot misjudged rotor blade clearance from a utility pole, which resulted in a collision. The proximity of the pole was a related factor.Jan 31, 1997 · N8319T · Substantial damage