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 SEA97LA032Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Forks, WAfuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.Nov 16, 1996 · N5225C · Substantial damageNTSB NYC97LA018Accident · No injuriesLimited investigationFinal reportDubis Team Minimax · North Adams, MAfuel contamination, which resulted in a loss of engine power. Factors relating to the accident were: the lack of a drain in the fuel system to properly check the fuel before flight, and the pilot's failure (or inability) to detect the contaminated fuel.Nov 16, 1996 · N4335W · Substantial damageNTSB LAX97LA043Accident · No injuriesLimited investigationFinal reportCessna T210L · Mesa, AZthe pilot's failure to maintain directional control of the aircraft during the landing roll, which resulted in an inadvertent ground swerve.Nov 16, 1996 · N911JB · Substantial damageNTSB IAD97FA023Accident · Serious injuriesField investigationFinal reportBeech 65-A90 · Orange, VAThe pilot's inadequate preflight inspection and his failure to complete the pretakeoff checklist which resulted in a takeoff roll with the control lock in place.Nov 16, 1996 · N814SW · DestroyedNTSB SEA97FA027Accident · 1 fatalField investigationFinal reportCessna P210N · Boring, ORThe pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.Nov 15, 1996 · N7823K · DestroyedNTSB LAX97LA042Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Apple Valley, CAfuel starvation, due to plugged fuel system vent lines, which resulted in loss of engine power.Nov 15, 1996 · N961T · Substantial damageNTSB IAD97FA022Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · West Milton, OHThe pilot's inability to maintain aircraft control after an undetermined failure of the automatic flight control. A contributing factor was failure of the maintenance technician to have the airplane test flown prior to release.Nov 15, 1996 · N8468H · DestroyedNTSB FTW97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Manvel, TXLoss of aircraft control due to the pilot's inadequate compensation for the crosswind. A factor was the crosswind.Nov 15, 1996 · N25JM · Substantial damageNTSB CHI97FA027Accident · 1 fatalField investigationFinal reportCessna T210N · Springfield, MOthe pilot's failure to set the altimeter to the current setting given by the controller resulting in the aircraft altimeter reading 260 feet higher than the actual aircraft altitude. Factors involved were pilot fatigue, weather conditions at approach…Nov 15, 1996 · N5083C · DestroyedNTSB LAX97LA303Accident · 1 fatalLimited investigationFinal reportFleming Glassair III · Dunsmuir, CAwas the pilot's intentional flight into marginal meteorological conditions in mountainous terrain during dark nighttime conditions.Nov 14, 1996 · N77DF · DestroyedNTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.Nov 14, 1996 · N1567P · Substantial damageNTSB LAX97LA040Accident · Serious injuriesLimited investigationFinal reportMoody RV-6 · Cottonwood, AZloss of engine power for undetermined reason(s).Nov 14, 1996 · N12033 · Substantial damageNTSB LAX97FA036Accident · 1 fatalField investigationFinal reportCessna 310I · Van Nuys, CAThe pilot's failure to maintain a climb following initiation of a missed approach in fog due to spatial disorientation, and his inadequate training by company personnel. Potential rescue was delayed due to the FAA radar controller's failure to follow…Nov 14, 1996 · N8046M · DestroyedNTSB NYC97WA017Accident · 8 fatalForeign investigationPiper PA-31-310 · Nairobi, KenyaNov 13, 1996 · 5YALA · DestroyedNTSB LAX97LA039Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Hana, HIsubsequent failure of the spur adapter gearshaft (SAG), after 'retaining ring to compressor impeller machining' occurred and allowed the SAG to shift aft. The mechanism which induced the ring to impeller machining was not determined. Mountainous terrain in…Nov 13, 1996 · N8625F · Substantial damageNTSB FTW97LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Plainview, TXthe pilot's continued descent below the minimum descent altitude (MDA). Factors relating to the accident were: darkness, the adverse weather conditions.Nov 13, 1996 · N5443 · Substantial damageNTSB IAD97IA020Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Cleveland, OHThe pilot's failure to follow checklist procedures and extend the spoilers.Nov 12, 1996 · N918DL · Minor damageNTSB FTW97LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Alamosa, COaircraft damage for undetermined rteasons.Nov 12, 1996 · N3293Y · Substantial damageNTSB FTW97FA039Accident · 1 fatalField investigationFinal reportCessna 182Q · Colorado City, TXthe pilot's encounter with instrument meteorological conditions (IMC), and his subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the clouds, low ceilings, and the pilot's lack of recent instrument…Nov 12, 1996 · N5116N · DestroyedNTSB DCA97WA007Accident · 349 fatalForeign investigationBoeing 747-168 · New Delhi, IndiaNov 12, 1996 · HZ-AIH · 2 aircraftNTSB CHI97LA026Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's improper recovery from a bounced landing. A factor was the pilot's misjudging the flare.Nov 12, 1996 · N55161 · Substantial damageNTSB LAX97LA037Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Williams, AZa foreign object in the oil system, which resulted in failure of the oil pump, oil starvation, loss of engine power, and a subsequent forced landing. Rough/uneven terrain in the emergency landing area was a related factor.Nov 11, 1996 · N714VX · DestroyedNTSB IAD97LA019Accident · 1 fatalLimited investigationFinal reportCessna 150 · Edgerton, OHthe pilot's Inadvertent VFR flight into instrument meteorological conditions resulting in spatial disorientation and subsequent loss of control of the airplane. Factors to this accident were the night conditions and snow.Nov 11, 1996 · N5627E · DestroyedNTSB CHI97FA025Accident · 3 fatalField investigationFinal reportEnstrom F28F · Gutherie, ILthe pilot's inadequate preflight preparation and not maintaining control of the helicopter during its rearward flight. A factor was the pilot's over-confidence in his personal ability.Nov 11, 1996 · N86214 · DestroyedNTSB ATL97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Cartersville, GAthe flight instructor's (CFI's) inadequate supervision by failing to ensure that directional control of the aircraft was maintained, during a simulated engine failure. The student pilot's delay in performing the appropriate single-engine emergency procedure…Nov 11, 1996 · N7392Y · Substantial damageNTSB FTW97LA057Accident · No injuriesLimited investigationFinal reportGilbert Rutan Vari EZE · Oklahoma City, OKThe pilot's failure to follow proper starting procedures and set the throttle to idle before hand propping.Nov 10, 1996 · N18VE · Substantial damageNTSB FTW97LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tulsa, OKFuel exhaustion due the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Nov 10, 1996 · N8960U · Substantial damageNTSB MIA97LA023Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Brunswick, GAa complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.Nov 9, 1996 · N86DR · Substantial damageNTSB MIA97LA022Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Columbiana, ALthe pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…Nov 9, 1996 · N6026T · Substantial damageNTSB MIA97LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Walnut Cove, NCfailure of the pilot/owner (PIC) to either go around while there was sufficient runway remaining or apply adequate braking to stop the aircraft before overrunning the runway. Factors relating to the accident were: the pilot/owner's misjudgment of distance and…Nov 9, 1996 · N8077M · Substantial damageNTSB MIA97FA020Accident · 3 fatalField investigationFinal reportPiper PA-60-600 · New Bern, NCthe pilot's failure to maintain airspeed (VMC). Contributing to the accident was his lack of total experience in kind of aircraft.Nov 9, 1996 · N8239J · DestroyedNTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.Nov 9, 1996 · N1014N · Substantial damageNTSB FTW97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Westcliffe, COfailure of the pilot to maintain directional control during the landing.Nov 9, 1996 · N1334A · Substantial damageNTSB MIA97FA021Accident · 1 fatalField investigationFinal reportCessna TU206B · Jasper, GAcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from rising/mountainous terrain. The adverse weather and terrain conditions were related factors.Nov 8, 1996 · N4970F · DestroyedNTSB IAD97IA018Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Dayton, OHFailure of the output drive unit shear pin due to lack of lubrication to the screw actuator assemblies. Contributing to the cause was the aircraft manufacturer's production and inspection personnel failing to lubricate the screw assemblies after initial…Nov 8, 1996 · N814DE · No damageNTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…Nov 7, 1996 · N32518 · Substantial damageNTSB SEA97LA026Accident · No injuriesLimited investigationFinal reportCessna 182G · Hardin, MTthe pilot's inadequate compensation for the wind conditions during the landing, and his failure to maintain directional control of the aircraft after touched down. Factors relating to the accident included the pilot's abrupt movement of the throttle as he…Nov 7, 1996 · N3126S · Substantial damageNTSB NYC97WA016Accident · 2 fatalForeign investigationBell 206B3 · Dear, South AfricaNov 7, 1996 · ZSHKB · DestroyedNTSB NYC97WA015Accident · 8 fatalForeign investigationCessna 421 · Donzeil, FranceNov 7, 1996 · HBLRX · DestroyedNTSB NYC97LA014Accident · Serious injuriesLimited investigationFinal reportCessna 340A · Pawtucket, RIfailure of the pilot to comply with the published instrument approach procedure, by continuing the ILS approach below the decision height, rather than performing a missed approach; and his failure to attain a proper touchdown point for the continued landing.…Nov 7, 1996 · N36JM · DestroyedNTSB LAX97LA038Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Elk Grove, CAloss of engine power for undetermined reason(s) after takeoff. The lack of maintenance/annual inspection was a related factor.Nov 7, 1996 · N30115 · Substantial damageNTSB NYC97FA013Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lehman Township, PAThe failure of the forward fuselage nose assembly for an undetermined reason, which resulted in an in-flight breakup of the airplane.Nov 6, 1996 · N5671V · DestroyedNTSB LAX97LA333Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG 15UTI · Fallon, NVThe pilot misjudged his altitude and airspeed. A related factor was his diverted attention.Nov 6, 1996 · N271JM · Substantial damageNTSB IAD97LA017Accident · Serious injuriesLimited investigationFinal reportVanatta KR-2 · Blackstone, VAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, which resulted in a loss of control (stall) and collision with the ground.Nov 6, 1996 · N85JV · Substantial damageNTSB DCA97WA005Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Buenos Aires, ArgentinaNov 6, 1996 · N271W · Minor damageNTSB SEA97LA025Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Leavenworth, WAFatigue failure of the vertical stabilizer spar cap and subsequent loss of the rotorcraft's vertical stabilizer. Factors include inadequate inspection or trouble-shooting of the aircraft tail cone and vertical stabilizer at and after the time sheet-metal…Nov 5, 1996 · N465JR · DestroyedNTSB IAD97LA016Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Gaithersburg, MDthe pilot's inadequate preflight, and his failure to detect an insufficent fuel supply, which resulted in fuel exhaustion and a forced landing after takeoff. Uneven terrain (drop-off in the emergency landing area) was a related factor.Nov 5, 1996 · N9926L · Substantial damageNTSB FTW97LA037Accident · No injuriesLimited investigationFinal reportCessna T210N · Grand Prairie, TXfailure of the pilot to ensure that the fuel selector was positioned to a tank with sufficient fuel, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's inadequate preflight, false indication from the…Nov 5, 1996 · N6546N · Substantial damageNTSB CHI97FA024Accident · 1 fatalField investigationFinal reportCessna 177B · Chancellor, SDthe pilot's attempted flight with known deficiencies in equipment, his initiating VFR flight into IMC conditions, his spatial disorientation and loss of control of the airplane. Factors were fog, dark night, and inoperative directional gyro.Nov 5, 1996 · N34994 · DestroyedNTSB NYC97LA012Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Laurens, NYthe student pilot's selection of an unsuitable area for a precautionary landing. Factors relating to the accident were: the student becoming lost, the subsequent low fuel condition, and the embankment in the emergency landing area.Nov 4, 1996 · N5541C · Substantial damage