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 CHI97LA107Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180 · Lakeville, MNthe pilot's inadequate compensation for the crosswind.Apr 19, 1997 · N5666N · Substantial damageNTSB ATL97FA060Accident · 1 fatalField investigationFinal reportBeech C23 · Athens, GApilot impairment of judgment and performance, due to alcohol; and his failure to maintain sufficient altitude or clearance from obstacles, while maneuvering at low altitude at night. Darkness was a related factor.Apr 19, 1997 · N6005T · DestroyedNTSB ANC97LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Delta Junction, AKfailure of the pilot to maintain directional control of the airplane.Apr 19, 1997 · N4217V · Substantial damageNTSB SEA97LA088Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Prescott, WAfailure of the pilot to maintain terrain clearance from uneven/hilly terrain.Apr 18, 1997 · N4978X · Substantial damageNTSB MIA97LA140Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe flight crew's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion.Apr 18, 1997 · N63666 · Substantial damageNTSB LAX97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tucson, AZThe partial blockage of the No. 2 cylinder injection line/nozzle by a transient contaminant, which induced an excessively lean mixture in that cylinder, and the subsequent overheating of the cylinder and intake valve. The engine power loss was due to the open…Apr 18, 1997 · N2847F · Substantial damageNTSB IAD97LA066Accident · No injuriesLimited investigationFinal reportGlobe GC-1-A · Wilmington, OHfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a collision with trees. Related factors were: the crosswind, and lack of experience in the make and model of airplane.Apr 18, 1997 · N80523 · Substantial damageNTSB CHI97LA106Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDa premature lift-off of the airplane by the pilot in command.Apr 18, 1997 · N1008P · Substantial damageNTSB ANC97LA057Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Palmer, AKthe pilot's inadequate preflight, and a foreign object (can) that became jammed under the rudder pedal, which resulted in an inadvertent activation of the right brake.Apr 18, 1997 · N333HT · Substantial damageNTSB ANC97LA053Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nikiski, AKthe pilot's improper installation of the landing gear wheel.Apr 18, 1997 · N92793 · Substantial damageNTSB LAX97LA162Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for the crosswind condition, and his failure to maintain directional control during landing. Factors related to the accident were: the crosswind, and the pilot's inadvertent unlocking of the tail wheel during a wheel…Apr 17, 1997 · N9013A · Substantial damageNTSB LAX97LA150Accident · 1 fatalLimited investigationFinal reportDuff MINI-500 · Lihue, Kauai, HIthe student pilot's improper use of the helicopter flight controls, which resulted in rotor contact with the tail boom and loss of control. Factors relating to the accident were: the pilot's lack of total and recent training and experience in airborne control…Apr 17, 1997 · N13118 · DestroyedNTSB LAX97IA161Incident · Minor injuriesIncident investigationFinal reportBoeing 737-500 · Rialto, CAa laser light source of undetermined origin, directed by unknown person(s) toward the cockpit window of the aircraft, while the aircraft was on an approach to land.Apr 17, 1997 · N930UA · No damageNTSB FTW97IA160Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Colorado Spgs, COAn oil leak around the APU aft bearing seal which resulted in a fire in the APU exhaust.Apr 17, 1997 · N962WP · No damageNTSB ANC97LA058Accident · No injuriesLimited investigationFinal reportCessna 185F · Manley, AKthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing run. Factors relating to the accident were: frozen terrain, adverse wind condition, and proximity of a snowbank.Apr 17, 1997 · N8310Q · Substantial damageNTSB SEA97LA087Accident · No injuriesLimited investigationFinal reportCessna A185E · Billings, MTThe flight instructor's inadequate compensation for the wind conditions. The crosswind conditions were a factor.Apr 16, 1997 · N70194 · Substantial damageNTSB NYC97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Belmar, NJThe student pilot's improper decision to taxi off the runway into sand after the nose gear collapsed. A factor in the accident was the student pilot's improper flare.Apr 16, 1997 · N321HP · Substantial damageNTSB NYC97LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJthe student pilot's improper recovery from a bounced landing which resulted in a hard landing, collapsed nose gear, loss of directional control, and subsequent nose over.Apr 16, 1997 · N1405E · Substantial damageNTSB MIA97TA139Accident · No injuriesFinal reportBell 204-B · Calderwood, TNThe inadequate maintenance inspection of the helicopter resulting in loss of lubrication from the main drive shaft going undetected until failure of the drive shaft.Apr 16, 1997 · N4580Y · DestroyedNTSB NYC97LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Butler, PAthe pilot's misjudgment of distance and speed on final approach; his failure to attain the proper touchdown point; and his failure to perform a go-around, while there was still sufficient airspeed and runway remaining, which resulted in an overrun and…Apr 15, 1997 · N21123 · Substantial damageNTSB NYC97FA076Accident · 1 fatalField investigationFinal reportEurocopter MBB-BK117-B2 · New York, NYFatigue failure of the vertical fin, accelerated by the installation of blind rivets in lieu of solid rivets in the replacement of the yaw SAS mount support, which resulted in the loss of helicopter directional control and collision with the terrain (water).…Apr 15, 1997 · N909CP · DestroyedNTSB FTW97TA162Accident · No injuriesFinal reportHughes OH-6A · Marfa, TXthe pilot's improper touchdown, and the designated examiner's inadequate supervision. The light condition at dusk was a related factor.Apr 15, 1997 · N6638P · Substantial damageNTSB CHI97LA112Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Wautoma, WIthe pilot's improper use of the throttle. Factors were a crosswind and soft terrain.Apr 15, 1997 · N26SH · Substantial damageNTSB CHI97LA104Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrisburg, ILthe loss of engine power followed by an engine fire for reason or reasons undetermined.Apr 15, 1997 · N3322T · DestroyedNTSB SEA97LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sequim, WAThe pilot-in-command's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor was trees in the forced landing area.Apr 14, 1997 · N8645P · Substantial damageNTSB NYC97LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Lumberton, NJThe pilot's delay in initiating remedial action to arrest an excessive descent rate during a go-around. A crosswind condition was a contributing factor.Apr 14, 1997 · N29M · Substantial damageNTSB MIA97LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Pickens, SCfailure of the student pilot to maintain directional control during the takeoff roll from a touch-and-go landing, which resulted in the airplane going off the side of the runway, down an embankment, and into brush/trees.Apr 14, 1997 · N5363W · Substantial damageNTSB LAX97LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · San Diego, CAThe pilot's decision to increase sink rate to avoid flying into an obstacle with insufficient altitude remaining to reduce the sink rate prior to impact with the ground.Apr 14, 1997 · N380P · Substantial damageNTSB ATL97LA059Accident · No injuriesLimited investigationFinal reportCessna 210D · Huntsville, ALcorrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.Apr 14, 1997 · N3761Y · Substantial damageNTSB SEA97LA090Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Plentywood, MTthe pilot's inadequate recovery from a bounced landing and failure to maintain control of the airplane. Factors relating to the accident included: the pilot's lack of recent experience in the tailwheel aircraft, his inadequate recurrent training, and…Apr 13, 1997 · N33976 · Substantial damageNTSB NYC97LA074Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Waynesboro, VAThe pilot's failure to maintain directional control during landing.Apr 13, 1997 · N2781H · DestroyedNTSB MIA97LA136Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Hollywood, FLthe student pilot's failure to maintain directional control during the landing/go-around, which led to subsequent in-flight collision with a fixed object (approach light/light bar/sign) and terrain. The student's failure to obtain the proper touchdown point…Apr 13, 1997 · N124MF · Substantial damageNTSB LAX97LA158Accident · 2 fatalLimited investigationFinal reportDevendorf Glassair GL25 · Congress, AZfailure of the pilot to recover from an inverted stall/spin prior to impact with the ground. The reason for the loss of control was not determined.Apr 13, 1997 · N28BD · DestroyedNTSB LAX97LA157Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Hilo, HIthe pilot's inadequate en route fuel consumption calculations, which led to his failure to recognize a deteriorating fuel duration versus time-to-go situation in a more timely way.Apr 13, 1997 · N242CA · DestroyedNTSB FTW97LA159Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Sinton, TXFuel starvation resulting from the failure of the engine driven fuel pump due to an undetermined reason. A factor was the soft terrain.Apr 13, 1997 · N6872 · Substantial damageNTSB ANC97LA062Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Koyuk, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the winds gusts and crosswind.Apr 13, 1997 · N53817 · Substantial damageNTSB MIA97WA135Accident · 4 fatalForeign investigationBeech A-36 · Pitts Town, BahamasApr 12, 1997 · N11RV · DestroyedNTSB LAX97LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Llano, CAthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper altitude and clearance from the boundry fence, during an approach to land on the runway. Factors relating to the accident were: the crosswind, and…Apr 12, 1997 · N2037T · Substantial damageNTSB LAX97LA155Accident · No injuriesLimited investigationFinal reportGordon Price Ultimate 10-300S · Yuma, AZthe pilot's failure to maintain adequate vertical clearance from the runway, while flying inverted. Factors relating to the accident were: the light conditions at dusk, and the pilot's lack of visual ques due to the light conditions.Apr 12, 1997 · N325GP · DestroyedNTSB FTW97LA158Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · El Paso, TXthe pilot's improper plannning/decision, which resulted in loss of engine power (both engines) due to fuel exhaustion. Darkness was a related factor.Apr 12, 1997 · XASBM · Substantial damageNTSB CHI97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Elk Falls, KSfracture of the fuel selector assembly which resulted in fuel starvation.Apr 12, 1997 · N8739P · Substantial damageNTSB CHI97FA102Accident · 2 fatalField investigationFinal reportCessna T210N · Vichy, MOfailure of the pilot to properly follow the missed approach procedure and maintain the minimum descent altitude (MDA) during night/IFR flight. Factors relating to the accident included: darkness, low ceiling, fog, and failure of the pilot to properly…Apr 12, 1997 · N5310A · DestroyedNTSB ANC97LA056Accident · No injuriesLimited investigationFinal reportBoeing 747-400 · Anchorage, AKAn in-flight collision with a large bird.Apr 12, 1997 · VRHUK · Substantial damageNTSB ANC97LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Quinhagak, AKA disconnected exhaust manifold collector, improper maintenance of the airplane by company maintenance personnel, and the pilot's poor judgement in electing to initiate another flight after observing smoke in the cockpit.Apr 12, 1997 · N9000N · Substantial damageNTSB MIA97LA137Accident · No injuriesLimited investigationFinal reportCessna 185D · Wetumpka, ALloss of engine power during a go-around for undetermined reason(s).Apr 11, 1997 · N285BG · Substantial damageNTSB LAX97FA156Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-300 · Minden, NVloss of aircraft control for undetermined reason(s), inadequate design of the canopy jettison system, and incapacitation of the pilot, when he was struck by the canopy frame during a jettison sequence.Apr 11, 1997 · N70644 · DestroyedNTSB ANC97MA161Accident · 5 fatalMajor investigationFinal reportCessna 208B · Wainwright, AKThe pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain altitude/clearance from terrain. Factors contributing to the accident were the weather conditions.Apr 11, 1997 · N408GV · DestroyedNTSB ANC97LA054Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Manokotak, AKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall of the airplane. A factor associated with the accident was the pilot's performance of a low altitude flight maneuver.Apr 11, 1997 · N8071D · DestroyedNTSB MIA97LA134Accident · No injuriesLimited investigationFinal reportNavion A · Quincy, FLchafing of an electrical cable that was routed through the firewall, which resulted in electrical arching and an in-flight fire.Apr 10, 1997 · N40FL · Substantial damageNTSB MIA97LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · La Crosse, FLThe student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…Apr 10, 1997 · N5442B · Substantial damage