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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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 terrainNTSB IAD98LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Winchester, VAImproper flare. A related factor was the pilot's diverted attention.NTSB CHI98LA154Accident · Serious injuriesLimited investigationFinal reportFokker F-28 MK100 · Ft. Wayne, INIn-flight encounter with turbulence.NTSB 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…NTSB CHI98LA150Accident · No injuriesLimited investigationFinal reportCessna A185F · Isanti, MNthe soft terrain condition. A factor was the failure of the crankshaft.NTSB 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.NTSB 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.NTSB IAD98LA056Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Cleveland, OHFailure of the pilot to extend the landing gear. A related factor was the diverted attention.NTSB 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…NTSB 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.NTSB DCA98WA047Accident · No injuriesForeign investigationBoeing 767 · Cairo, EgyptNTSB 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.NTSB 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…NTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.NTSB MIA98WA157Accident · Serious injuriesForeign investigationCessna 421B · Nassau, BahamasNTSB MIA98LA158Accident · No injuriesLimited investigationFinal reportDavid McElhannon Avid MK. 4 · Elberton, GAA loss of engine power due to a failed combustion assembly, expansion seal.NTSB IAD98LA053Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Nashua, NHThe pilot's improper fuel management which led to fuel starvation.NTSB DCA98WA043Accident · Serious injuriesForeign investigationBoeing 747 · Narita, JapanNTSB CHI98TA145Accident · Minor injuriesFinal reportPiper PA-18-150 · Artesian, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB 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.NTSB 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.NTSB 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.NTSB FTW98LA213Accident · No injuriesLimited investigationFinal reportBeech A-36 · Ruidoso, NMInadvertent post departure stall. A factor was high gusty winds.NTSB 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.NTSB 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.NTSB 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).NTSB CHI98LA143Accident · 2 fatalLimited investigationFinal reportAlon A-2 · Cedar Hills, MOthe failure of the pilot to maintain airplane control due to alcohol impairment.NTSB SEA98TA074Accident · Minor injuriesFinal reportBell UH-1H · Naches, WALoss of engine power for undetermined reasons.NTSB 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.NTSB MIA98LA154Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe loss of engine power for undetermined reasons.NTSB 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.NTSB 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,…NTSB 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.NTSB MIA98WA156Accident · 1 fatalForeign investigationPiper PA-23-250 · Walker'S Cay, BahamasNTSB 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.NTSB 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.NTSB FTW98IA208Incident · No injuriesIncident investigationFinal reportBoeing 727-25C · Colorado Sprngs, COAn inadvertent inflight collision with a flock of large birds.NTSB 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.NTSB 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.NTSB SEA98LA072Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Toledo, WAPartial loss of power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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…