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 MIA97LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Key Largo, FLthe pilot's failure to maintain directional control during a crosswind landing, which resulted in an inadvertent ground swerve and collision with bushes and terrain.Apr 27, 1997 · N4141M · Substantial damageNTSB LAX97LA169Accident · No injuriesLimited investigationFinal reportCameron N-77 · Temecula, CAThe pilot's misjudgment of his speed and altitude, which led to a landing overshoot.Apr 27, 1997 · N16067 · DestroyedNTSB FTW97LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Canon City, COThe pilot's failure to maintain an adequate visual lookout. A factor was the pilot's attention being diverted.Apr 27, 1997 · N2326H · DestroyedNTSB DCA97WA043Accident · No injuriesForeign investigationMcDonnell Douglas MD-82 · Jinan, ChinaApr 27, 1997 · B2135 · Substantial damageNTSB CHI97LA118Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAfailure of the student pilot to maintain directional control, inadequate supervision by the flight instructor (CFI), and subsequent failure of the pilot(s) to properly flare the helicopter during a hover autorotation.Apr 27, 1997 · N1040S · Substantial damageNTSB CHI97LA115Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Duluth, MNthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control.Apr 27, 1997 · N7355Q · Substantial damageNTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.Apr 27, 1997 · N52260 · Substantial damageNTSB SEA97LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYThe pilot's inadequate preflight planning. Factors include high density altitude, downdrafts, and rough/uneven terrain in the area where the pilot attempted the emergency landing.Apr 26, 1997 · N6121J · Substantial damageNTSB SEA97LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Ilwaco, WAThe student pilot's failure to land the aircraft at the proper touchdown point. Factors include inadequate preflight planning/preparation by the student pilot, inadequate supervision by the student pilot's flight instructor, rain, fog, strong crosswinds, a…Apr 26, 1997 · N152TM · Substantial damageNTSB LAX97LA168Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Hemet, CAthe pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…Apr 26, 1997 · N5482N · DestroyedNTSB FTW97FA171Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Rye, COThe pilot initiating flight into IMC conditions in mountainous terrain. Factors were mountainous terrain, low ceiling, snow, preflight planning, and in-flight planning and decision making.Apr 26, 1997 · N2225A · DestroyedNTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.Apr 26, 1997 · N3126Z · DestroyedNTSB ATL97LA063Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lincolnton, GAThe pilot's inadequate preflight planning of the fuel requirement for this flight that resulted in fuel exhaustion and the subsequent loss of engine power.Apr 26, 1997 · N8473V · Substantial damageNTSB ANC97LA069Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Selawik, AKThe pilot's failure to extend the landing gear. A factor associated with the accident was the pilot's diverted attention while in the landing pattern.Apr 26, 1997 · N59985 · Substantial damageNTSB LAX97LA167Accident · Serious injuriesLimited investigationFinal reportCessna 172P · San Jose, CAThe student pilot's failure to maintain adequate airspeed to preclude stalling following an improper recovery from a bounced landing. Contributing factors were the pilot's premature and excessive flap retraction and misjudged landing flare.Apr 25, 1997 · N63754 · DestroyedNTSB ATL97LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Clearwater, FLThe pilot's failure to select the fuller tank for takeoff that resulted in fuel starvation to the engine, and the subsequent total loss of engine power.Apr 25, 1997 · N2351V · Substantial damageNTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.Apr 24, 1997 · N133R · Substantial damageNTSB MIA97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLloss of engine for undetermined reason(s), which resulted in a forced landing and subsequent collision with a fence.Apr 24, 1997 · N6299A · Substantial damageNTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.Apr 24, 1997 · N733PM · Substantial damageNTSB CHI97LA113Accident · No injuriesLimited investigationFinal reportCessna 185 · Pella, IAthe pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.Apr 24, 1997 · N4641E · Substantial damageNTSB MIA97LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Augusta, GAflight by the pilot into known adverse weather conditions, which resulted in a loss of aircraft control during the landing flare, and collision with the terrain. The adverse weather with nearby thunderstorm activity, crosswind, and gusts was a related factor.Apr 23, 1997 · N1321H · Substantial damageNTSB FTW97TA165Accident · Minor injuriesFinal reportBell 206-L1 · Trinidad, COThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. A factor was the tailwind condition and the pilot's failure to maintain proper airspeed.Apr 23, 1997 · N618DE · Substantial damageNTSB FTW97LA178Accident · Serious injuriesLimited investigationFinal reportRans S-12 · Goldsby, OKthe pilot-in-command's improper judgment in allowing the passenger to control the airplane, and the pilot-in-command's inadequate supervision. Factors relating to the accident were: the passenger's failure to maintain minimum required airspeed, which resulted…Apr 23, 1997 · UNREG · DestroyedNTSB FTW97FA166Accident · 1 fatalField investigationFinal reportSocata TB-20 · Pagosa Springs, COinadvertent flight by the pilot into known adverse weather conditions, and his failure to maintain altitude or clearance from terrain. Factors relating to the accident were: low ceiling, rain, snow, icing conditions, and mountainous terrain.Apr 23, 1997 · N20NK · DestroyedNTSB ANC97LA075Accident · No injuriesLimited investigationFinal reportCessna 207A · Minto, AKThe pilot's inadequate preflight inspection of the airplane, which resulted in an unlatched door opening in-flight.Apr 23, 1997 · N1785U · Substantial damageNTSB NYC97LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lehighton, PAreplacement of the flap actuating system fuse by the pilot-in-command with the flap actuating handle in the fully retracted position. This resulted in the retraction of the flaps, an inadvertent stall/mush, and the subsequent in-flight collision with terrain.Apr 22, 1997 · N6717F · Substantial damageNTSB CHI97LA110Accident · Serious injuriesLimited investigationFinal reportGulfstream 500B · Mission, KSthe pilot's inadequate preflight planning which resulted in fuel exhaustion.Apr 22, 1997 · N4918 · Substantial damageNTSB ANC97LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Ninilchik, AKfailure of the pilot to maintain altitude/clearance from a closed runway, while making a low pass, which resulted in an inadvertent touchdown.Apr 22, 1997 · N5407R · Substantial damageNTSB MIA97LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ackerman, MSinstallation of an incorrect fuel filter in the fuel tanker, which allowed water-contaminated fuel being dispensed into the aircraft, subsequent partial loss of engine power on initial takeoff climb, and a forced landing. The lack of suitable terrain for a…Apr 21, 1997 · N6601Q · Substantial damageNTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.Apr 21, 1997 · N3101X · Substantial damageNTSB FTW97LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinney, TXthe student pilot's failure to maintain directional control on the ground after recovery from a bounced landing.Apr 21, 1997 · N54153 · Substantial damageNTSB CHI97LA109Accident · No injuriesLimited investigationFinal reportCessna 421C · Pierre, SDthe pilot's inadvertent activation of the number one throttle/power control. Factors were: the pilot left the cockpit unattended with the engines running and a wet ramp.Apr 21, 1997 · N283PT · Substantial damageNTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.Apr 21, 1997 · N242BS · DestroyedNTSB ATL97IA061Incident · No injuriesIncident investigationFinal reportBritish Aerospace 125-800A · Chamblee, GAphysical impairmant of the captain during flight, which was the resulted of a kidney stone.Apr 21, 1997 · N900KC · No damageNTSB ANC97LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Soldotna, AKthe pilot's inadequate compensation for cross conditions and failure to maintain directional control of the airplane. A factor relating to the accident was: the variable/gusty/crosswind condition.Apr 21, 1997 · N64337 · Substantial damageNTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.Apr 20, 1997 · N61S · Substantial damageNTSB IAD97LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wellsville, NYthe student pilot's improper flare, improper recovery from a bounced landing, and loss of directional control, during the landing.Apr 20, 1997 · N2477K · Substantial damageNTSB IAD97FA065Accident · 2 fatalField investigationFinal reportLockheed PV2 · Blandburg, PAPilot in command misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, windy conditions, turbulence in the area, and smoke.Apr 20, 1997 · N6856C · DestroyedNTSB FTW97IA161Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Houston, TXThe first officer's failure to maintain clearance while taxiing around a standing airplane.Apr 20, 1997 · PHBUL · Minor damageNTSB CHI97LA108Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Sioux Falls, SDthe ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.Apr 20, 1997 · N71493 · No damageNTSB SEA97LA091Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · West Jordan, UTlanding gear collapsed for undetermined reasons.Apr 19, 1997 · N616AS · Substantial damageNTSB SEA97LA089Accident · 1 fatalLimited investigationFinal reportIvan Langston Hawk · Howell, UTThe pilot's failure to maintain control of the aircraft. Heavy rain and gusting winds were a factor.Apr 19, 1997 · N627K · Substantial damageNTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.Apr 19, 1997 · N9063K · Substantial damageNTSB MIA97LA143Accident · No injuriesLimited investigationFinal reportCessna 150G · Raleigh, NCfailure of the pilot to maintain proper runway alignment during the attempted landing and go-around. Factors relating to the accident were: the gusty crosswind condition, and proximity of trees to the runway.Apr 19, 1997 · N3235X · Substantial damageNTSB MIA97LA141Accident · 1 fatalLimited investigationFinal reportYoung Merlin GT · Fort Myers, FLthe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/spin and subsequent collision with the terrain. Factors relating to the accident were: the pilot's failure to use all available runway, and…Apr 19, 1997 · N2100S · DestroyedNTSB MIA97IA147Incident · No injuriesIncident investigationFinal reportBoeing 747-2R7F · Miami, FLdisbonding and separation of the right inboard wing fixed trailing edge panel during cruise flight, which resulted in damage to the inboard fore flap and inboard mid flap, and a subsequent precautionary landing at the departure airport.Apr 19, 1997 · N639FE · Minor damageNTSB LAX97LA165Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Hemet, CAthe pilot's failure to adjust his traffic pattern to compensate for local atmospheric conditions.Apr 19, 1997 · N90620 · Substantial damageNTSB LAX97FA164Accident · Serious injuriesField investigationFinal reportBoeing 737-3S3 · Las Vegas, NVinadequate service provided by the TRACON controller, by issuing a radar vector to the Boeing 737 flight, which resulted in inadequate separation from a Beech 99 that the controller had just terminated from radar service; and failure of the controller to…Apr 19, 1997 · N313AW · No damageNTSB FTW97LA169Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Fluvanna, TXThe loss of engine power due to the failure of the reduction gear box. A factor was the lack of suitable terrain for the forced landing.Apr 19, 1997 · N73127 · Substantial damageNTSB CHI97LA111Accident · No injuriesLimited investigationFinal reportCessna 177 · Rantoul, ILthe student pilot's improper flare and improper recovery from a bounced landing.Apr 19, 1997 · N3489T · Substantial damage