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 FTW98LA217Accident · No injuriesLimited investigationFinal reportAyres SR2-T34 · Dewitt, ARThe pilot's failure to maintain proper clearance from a fixed obstacle [utility pole] while maneuvering. A factor was pilot fatigue.May 14, 1998 · N393KW · Substantial damageNTSB CHI98LA166Accident · No injuriesLimited investigationFinal reportEnstrom F28 · West Chicago, ILthe student pilot attempting a tailwind landing and improper compensation for the wind resulting in too high of a sink rate and the hard landing.May 14, 1998 · N86238 · Substantial damageNTSB ATL98FA076Accident · Serious injuriesField investigationFinal reportBeech BE-45-T-34B · Montgomery, ALThe installation of an incorrect engine nose seal that subsequently dislodged from the normally installed position, and resulted in the loss of engine power. A factor was the loss of engine oil.May 14, 1998 · N9280Z · DestroyedNTSB ANC98FA046Accident · Serious injuriesField investigationFinal reportCessna 208 · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings, whiteout conditions, and snow covered terrain.May 14, 1998 · N192AV · Substantial damageNTSB MIA98LA161Accident · No injuriesLimited investigationFinal reportRevolution MINI-500 · Villa Rica, GAThe pilot's choice of landing area during a precautionary landing adjacent to the runway. This resulted in an in-flight collision of the left skid with a rock during a cyclic flare, loss of directional control, and subsequent collision of the main rotor blade…May 13, 1998 · N355RM · Substantial damageNTSB MIA98LA160Accident · 2 fatalLimited investigationFinal reportM2 Sport 1000 · Semmes, ALThe pilot's failure to maintain control of the aircraft after an encounter with turbulence during initial climb out. A related factor was the turbulence.May 13, 1998 · UNREG · DestroyedNTSB LAX98LA156Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Gorman, CAThe pilot's failure to maintain airspeed and an inadvertent stall while attempting to reverse direction in low cloud conditions in mountainous terrainMay 13, 1998 · N11867 · DestroyedNTSB IAD98LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Winchester, VAImproper flare. A related factor was the pilot's diverted attention.May 13, 1998 · N1142C · Substantial damageNTSB CHI98LA154Accident · Serious injuriesLimited investigationFinal reportFokker F-28 MK100 · Ft. Wayne, INIn-flight encounter with turbulence.May 13, 1998 · N1400H · No damageNTSB CHI98LA152Accident · No injuriesLimited investigationFinal reportRead Rotorway Executive · Valparaiso, INthe pilot not maintaining adequate clearance with the ground during hover. Factors which contributed to this accident were the pilot's execution of a hovering turn at too low of an altitude, inadequate preflight preparation, and failing to remove the…May 13, 1998 · N4561C · Substantial damageNTSB CHI98LA150Accident · No injuriesLimited investigationFinal reportCessna A185F · Isanti, MNthe soft terrain condition. A factor was the failure of the crankshaft.May 13, 1998 · N7140H · Substantial damageNTSB LAX98LA155Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Holbrook, AZThe pilot's failure to maintain directional control during a go-around after encountering a gust of wind.May 12, 1998 · N6092N · Substantial damageNTSB IAD98LA057Accident · No injuriesLimited investigationFinal reportHughes 269A · Alexandria Bay, NYFailure of the pilot to maintain rotor rpm during practice autorotation, and the flight instructor's inadequate supervision.May 12, 1998 · N8045H · Substantial damageNTSB IAD98LA056Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Cleveland, OHFailure of the pilot to extend the landing gear. A related factor was the diverted attention.May 12, 1998 · N1AS · Substantial damageNTSB IAD98FA054Accident · 4 fatalField investigationFinal reportBeech A36 · Davis, WVThe pilot's spatial disorientation, his subsequent loss of control of the airplane, and his overload of the horizontal stabilizer during a recovery attempt. Factors include the pilot's continued flight into icing conditions, his lack of airspeed control, and…May 12, 1998 · N72141 · DestroyedNTSB FTW98FA215Accident · 1 fatalField investigationFinal reportBeech 76 · Frisco, TXThe pilot's failure to maintain control resulting in an inadvertent stall while performing simulated single engine maneuvers during a practical test for a multiengine rating.May 12, 1998 · N6701C · DestroyedNTSB DCA98WA047Accident · No injuriesForeign investigationBoeing 767 · Cairo, EgyptMay 12, 1998 · UNK · 2 aircraft · Substantial damageNTSB CHI98LA151Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Monroe, MIthe pilot-in-command's inability to rotate during takeoff due to restricted movement of the elevator controls for undetermined reasons.May 12, 1998 · N617GA · Substantial damageNTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…May 12, 1998 · N5876G · Substantial damageNTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.May 12, 1998 · N199DD · DestroyedNTSB MIA98WA157Accident · Serious injuriesForeign investigationCessna 421B · Nassau, BahamasMay 11, 1998 · N17BN · Substantial damageNTSB MIA98LA158Accident · No injuriesLimited investigationFinal reportDavid McElhannon Avid MK. 4 · Elberton, GAA loss of engine power due to a failed combustion assembly, expansion seal.May 11, 1998 · N117DK · Substantial damageNTSB IAD98LA053Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Nashua, NHThe pilot's improper fuel management which led to fuel starvation.May 11, 1998 · N7795Q · DestroyedNTSB DCA98WA043Accident · Serious injuriesForeign investigationBoeing 747 · Narita, JapanMay 11, 1998 · N179UA · No damageNTSB CHI98TA145Accident · Minor injuriesFinal reportPiper PA-18-150 · Artesian, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall.May 11, 1998 · N83679 · Substantial damageNTSB CHI98LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hannibal, MOa loss of engine power due to undetermined reasons. A factor was the rough field in which the forced landing was made.May 11, 1998 · N733HY · Substantial damageNTSB LAX98IA158Incident · No injuriesIncident investigationFinal reportNorth American NA265-65 · Palm Springs, CAthe fatigue failure and uncontained separation of the high pressure impeller in the No. 2 engine during the takeoff roll. While the impeller showed evidence of a subsurface fatigue origin, the percipient cause of the separation was not definitively determined.May 10, 1998 · N651MK · Minor damageNTSB FTW98LA214Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Salt Lake City, UTThe pilot's inadequate compensation for winds while taxing. A factor was gusty, high wind conditions.May 10, 1998 · N8178K · DestroyedNTSB FTW98LA213Accident · No injuriesLimited investigationFinal reportBeech A-36 · Ruidoso, NMInadvertent post departure stall. A factor was high gusty winds.May 10, 1998 · N6150X · Substantial damageNTSB FTW98LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Georgetown, TXinadequate supervision by the flight instructor (CFI), by failing to ensure that the student obtained and/or maintained sufficient airspeed, which led to an inadvertent stall and collision with the terrain.May 10, 1998 · N99570 · Substantial damageNTSB FTW98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain available for the forced landing.May 10, 1998 · N67326 · Substantial damageNTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).May 10, 1998 · N1491D · Substantial damageNTSB CHI98LA143Accident · 2 fatalLimited investigationFinal reportAlon A-2 · Cedar Hills, MOthe failure of the pilot to maintain airplane control due to alcohol impairment.May 10, 1998 · N5482E · DestroyedNTSB SEA98TA074Accident · Minor injuriesFinal reportBell UH-1H · Naches, WALoss of engine power for undetermined reasons.May 9, 1998 · N345SC · Substantial damageNTSB SEA98LA073Accident · No injuriesLimited investigationFinal reportAero Commander 500-A · Billings, MTFailure of the main landing gear strut outer-body to inner-body needle bearing from the lack of lubrication and the development of corrosion. An inadequate manufacturer's inspection program was a factor.May 9, 1998 · N9382R · Substantial damageNTSB MIA98LA154Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe loss of engine power for undetermined reasons.May 9, 1998 · N6714D · Substantial damageNTSB MIA98LA153Accident · No injuriesLimited investigationFinal reportCessna 172N · West Palm Beach, FLthe dual student's failure to use carburetor heat while circling at a reduced power setting, and the flight instructor's failure to properly supervise the student.May 9, 1998 · N733LW · Substantial damageNTSB LAX98LA181Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mesa, AZFailure of a weld in the engine's throttle control support assembly due to inadequate maintenance which was the ultimate responsibility of the owner-pilot. Contributing factors were the presence of rough terrain, the lack of a suitable forced landing site,…May 9, 1998 · N7447H · Substantial damageNTSB FTW98LA211Accident · Serious injuriesLimited investigationFinal reportEller BD-5B · Falcon, COThe vibration induced overload failure of the canopy holdback fitting resulting in reduced control capability. A factor was partial failure of one propeller blade for unknown reasons.May 9, 1998 · N194EC · Substantial damageNTSB MIA98WA156Accident · 1 fatalForeign investigationPiper PA-23-250 · Walker'S Cay, BahamasMay 8, 1998 · N5813Y · Substantial damageNTSB MIA98LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Luvurne, ALThe loss of engine power due to a leaking engine oil seal, resulting in a forced landing, and subsequent impact with the ground. A factor in this accident was improper maintenance and checks after rebuilding and reinstalling the airplane's engine.May 8, 1998 · N8218N · Substantial damageNTSB IAD98LA055Accident · No injuriesLimited investigationFinal reportCessna 177B · Prattsville, OHthe pilot's inadequate preflight inspection and the inadequate fuel consumption calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Uneven terrain in the forced landing area was a related factor.May 8, 1998 · N904DS · Substantial damageNTSB FTW98IA208Incident · No injuriesIncident investigationFinal reportBoeing 727-25C · Colorado Sprngs, COAn inadvertent inflight collision with a flock of large birds.May 8, 1998 · N116FE · Minor damageNTSB ATL98LA075Accident · No injuriesLimited investigationFinal reportCessna 310Q · Lafayette, GAThe pilot's improper flare during landing. Factors were the pilot's lack of familiarity with the airplane and the crosswind condition.May 8, 1998 · N310DR · Substantial damageNTSB ATL98LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Hendersonville, NCThe pilot's failure to attain the proper touchdown point and improper go-around procedures resulting in collision with wires, trees, and the ground. Factors were the pilot's lack of familiarity with the airplane and the short runway.May 8, 1998 · N7312Y · Substantial damageNTSB SEA98LA072Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Toledo, WAPartial loss of power for undetermined reasons.May 7, 1998 · N8659K · Substantial damageNTSB MIA98FA155Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fargo, GAthe left engine propeller blades struck the runway surface during takeoff, resulting in the pilot losing control of the airplane, and subsequently impacting with trees.May 7, 1998 · N4BN · DestroyedNTSB LAX98FA152Accident · 4 fatalField investigationFinal reportCessna 172N · Avalon, CAThe pilot's failure to maintain adequate altitude/clearance in a Blind/Box Canyon. A related factor was the mountainous/hilly terrain.May 7, 1998 · N6514E · DestroyedNTSB FTW98LA205Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Forrest City, ARThe pilot's failure to maintain clearance with terrain. Factors were the sunglare and the pilot's restriction to visibility due to chemicals on the windshield.May 7, 1998 · N91660 · Substantial damageNTSB DCA98MA045Accident · Serious injuriesMajor investigationFinal reportDouglas DC-9-32 · Calhoun, GAThe failure of the flight crew to maintain adequate separation from hazardous meteorological conditions. Factors contributing to the accident were: (1) the failure of AirTran Airlines to provide adequate crewmember training and guidance regarding hazardous…May 7, 1998 · N948VV · Substantial damage