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 SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.Dec 24, 1995 · N738ME · Substantial damageNTSB SEA96FA034Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kapowsin, WAthe pilot's failure to maintain aircraft control and terrain clearance. Turbulence was a factor.Dec 24, 1995 · N4008Z · Substantial damageNTSB FTW96LA076Accident · No injuriesLimited investigationFinal reportCessna 150M · Round Rock, TXThe pilot's improper planning/decision, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Dec 24, 1995 · N19LV · Substantial damageNTSB FTW96FA075Accident · 2 fatalField investigationFinal reportAero Commander 112 · Carlsbad, NMThe pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's lack of total actual instrument weather time and the clouds.Dec 24, 1995 · N1152J · DestroyedNTSB CHI96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wheeling, ILthe pilot's misjudgment of the landing flare.Dec 24, 1995 · N8162S · Substantial damageNTSB NYC96LA042Accident · No injuriesLimited investigationFinal reportCessna 150G · East Hampton, NYfailure of the flight instructor to adequately supervise the dual student pilot and ensure that directional control of the airplane was maintained. The icy runway was a related factor.Dec 23, 1995 · N2970J · Substantial damageNTSB LAX96LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Bakersfield, CAthe pilot's improper aborted landing procedure which resulted in the aircraft stalling and impacting terrain.Dec 23, 1995 · N73303 · Substantial damageNTSB LAX96FA249Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Death Valley, CAthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions.Dec 23, 1995 · N7304P · DestroyedNTSB LAX96FA078Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · San Jose, CAThe failure of the air traffic controller to comply with instructions contained in the Air Traffic Control Handbook, FAA Order 7110.65, which resulted in the flight being vectored at an altitude below the minimum vectoring altitude (MVA) and failure to issue…Dec 23, 1995 · N27954 · DestroyedNTSB CHI96FA065Accident · 2 fatalField investigationFinal reportMumm Lancair · Morris, MNthe partially blocked elevator and improper installation of the elevator bob weight by the owner/builder which prevented full travel of the elevator control system. Factors relating to this accident were the intentional stall and inability to adequately…Dec 23, 1995 · N2114Z · DestroyedNTSB MIA96WA054Accident · No injuriesForeign investigationDouglas DC-3 · Nassau, BahamasDec 22, 1995 · N123DZ · Substantial damageNTSB FTW96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Waller, TXthe pilot's failure to maintain obstacle clearance.Dec 22, 1995 · N9591D · Substantial damageNTSB CHI96LA057Accident · No injuriesLimited investigationFinal reportBeech 58 · Minneapolis, MNthe pilot-in-command's abrupt maneuvering during the circling approach. The factors involved were the airframe ice and fog.Dec 22, 1995 · N222RB · Substantial damageNTSB FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…Dec 21, 1995 · N421EP · DestroyedNTSB DCA96RA020Accident · 160 fatalForeign investigationBoeing B757 · Buga, ColombiaDec 21, 1995 · N651AANTSB CHI96LA060Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe failure of the turbocharger, caused by a unapproved rebuild of the turbocharger which contained automotive parts. Debris from the failed turbocharger damaged the oil pump resulting in lack of engine lubrication.Dec 21, 1995 · N5083C · Substantial damageNTSB BFO96FA032Accident · 3 fatalField investigationFinal reportCessna 310R · Bellville, OHthe pilot's in-flight loss of aircraft control for undetermined reason(s), which resulted in the airplane exceeding its design stress limitations and an in-flight breakup.Dec 21, 1995 · N1269G · DestroyedNTSB LAX96FA076Accident · 1 fatalField investigationFinal reportHughes 369D · Feather Falls, CAthe pilot's failure to jettison his external load after it came in contact with trees and terrain. The pilot's failure to maintain altitude/clearance above trees and hilly terrain was a related factor.Dec 20, 1995 · N8395F · DestroyedNTSB DCA96MA029Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 747-136 · Jamaica, NYthe captain's failure to reject the takeoff in a timely manner when excessive nosewheel steering tiller inputs resulted in a loss of directional control on a slippery runway. Inadequate Boeing 747 slippery runway operating procedures developed by Tower Air,…Dec 20, 1995 · N605FF · Substantial damageNTSB BFO96LA031Accident · Minor injuriesLimited investigationFinal reportBellanca BL14-19-3 · Toledo, OHan improper splice of the magneto 'P' lead wires, and the pilot's improper positioning of the throttle and mixture controls while he rotated the propeller by hand.Dec 20, 1995 · N7624E · DestroyedNTSB ATL96LA025Accident · 1 fatalLimited investigationFinal reportMoravan Zlin Z50 LA · Springfield, TNthe pilot's failure to maintain control of the aircraft.Dec 20, 1995 · N6660B · DestroyedNTSB MIA96FA048Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Memphis, TNthe pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.Dec 19, 1995 · N8349Z · DestroyedNTSB LAX96FA075Accident · Serious injuriesField investigationFinal reportGreat Lakes 2T-1A-2 · Fillmore, CAfailure of the pilot to take proper remedial action to recover from an intentional spin.Dec 19, 1995 · N3511L · DestroyedNTSB CHI96IA059Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Saint Louis, MOloss of induction air into the engine inlets resulting in simultaneous loss of power on both engines. Factors relating to this incident were: disconnection of the airplane's hydraulic pumps and generators, slush on the runway and the hydroplaning condition.Dec 19, 1995 · N925L · No damageNTSB ATL96LA024Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Monroe, NCThe pilot's inadequate planning and failure to follow operating procedures resulted in his descent below the decision height while on final approach.Dec 19, 1995 · N4219T · Substantial damageNTSB MIA96FA047Accident · 3 fatalField investigationFinal reportCessna 205 · Culebra, PRFailure of the pilot to maintain sufficient altitude/clearance above the terrain, while maneuvering at night. Factors relating to the accident were: darkness with no visible horizon, and the pilot's lack of recent experience in night flight.Dec 18, 1995 · N8415Z · DestroyedNTSB FTW96LA074Accident · No injuriesLimited investigationFinal reportBeech 200 · Ingleside, TXThe pilot's improper decision, while evading law enforcement personnel during an illegal/unauthorized operation.Dec 18, 1995 · N231RL · Substantial damageNTSB ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationDec 18, 1995 · N234SM · Substantial damageNTSB ANC96LA020Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Nome, AKThe pilot exceeding the weight and balance limitations of the airplane and improperly utilizing the airplane's elevator trim by selecting full nose up trim.Dec 18, 1995 · N340K · Substantial damageNTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.Dec 17, 1995 · N143JP · Substantial damageNTSB SEA96FA031Accident · 1 fatalField investigationFinal reportCessna T210M · Netarts, ORa loss of control for undetermined reasons.Dec 17, 1995 · N732TA · DestroyedNTSB MIA96LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bryceville, FLThe pilot's improper planning/decision. Factors relating to the accident were: the pilot's inaccurate evaluation of the weather conditions, the pilot becoming lost/disoriented, and the lack of braking action on wet grass during the precautionary landing.Dec 17, 1995 · N75938 · Substantial damageNTSB MIA96LA043Accident · 2 fatalLimited investigationFinal reportPro Star PRO Tech · Sebring, FLthe pilot-in-command(CFI) allowed the airplane's design limits to be exceeded which resulted in the overload failure and separation of the right wing.Dec 17, 1995 · N2071H · DestroyedNTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.Dec 17, 1995 · N9379T · Substantial damageNTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.Dec 17, 1995 · N12010 · Substantial damageNTSB SEA96LA030Accident · No injuriesLimited investigationFinal reportCessna 170B · John Day, ORThe pilot's failure to maintain a proper glidepath.Dec 16, 1995 · N3171B · Substantial damageNTSB NYC96LA041Accident · No injuriesLimited investigationFinal reportCessna U206G · Bangor, MEthe pilot's improper inflight planning/decision, and his failure to properly plan his approach for landing, so that the airplane would not stall or touchdown hard. Factors relating to the accident were: the adverse weather (icing) condition, the accumulation…Dec 16, 1995 · N6250X · Substantial damageNTSB MIA96LA045Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLThe pilot's failure to properly plan the flight.Dec 16, 1995 · N254BA · Substantial damageNTSB MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.Dec 16, 1995 · N102DJ · Substantial damageNTSB FTW96FA072Accident · 2 fatalField investigationFinal reportBeech 35 · Kremmling, COa loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…Dec 16, 1995 · N1969D · DestroyedNTSB FTW96FA071Accident · 2 fatalField investigationFinal reportCessna 150M · S Padre Island, TXVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the surface of the water. Factors relating to the accident were: the adverse weather conditions (low ceiling and…Dec 16, 1995 · N3862V · DestroyedNTSB CHI96LA058Accident · No injuriesLimited investigationFinal reportCessna 150B · Grant, MIthe pilot's selection of unsuitable terrain and the weak ice-covered runway.Dec 16, 1995 · N1219Y · Substantial damageNTSB CHI96LA055Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Mason, MIthe improper application of the throttle by the pilot resulting in a delayed engine response, and the improper decision by the pilot to make a long fast touchdown requiring the need to take off under powerlines.Dec 16, 1995 · N990WY · Substantial damageNTSB CHI96LA054Accident · Minor injuriesLimited investigationFinal reportBitonti Wittman WT-8 · Plymouth, MIa stuck exhaust valve resulting in an overtemperature condition of the cylinder, the pilot's continued operation without corrective maintenance, and his failure to maintain aircraft control.Dec 16, 1995 · N88TK · DestroyedNTSB ANC96LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Newtok, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident are the snow covered runway, and gusty crosswinds.Dec 16, 1995 · N755AB · Substantial damageNTSB CHI96LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226AT · Detroit, MIthe pilot's failure to extend the landing gear. A factor in the accident was the pilot's diverted attention.Dec 15, 1995 · N31AT · Substantial damageNTSB SEA96FA029Accident · 1 fatalField investigationFinal reportCessna 340A · Mead, WAthe pilot's failure to maintain terrain clearance in mountainous terrain. Factors contributing to the accident were: dark night conditions, mountainous terrain, and instrument meteorological conditions.Dec 14, 1995 · N5GM · DestroyedNTSB MIA96WA046Accident · 2 fatalForeign investigationAero Commander 1121 · Guatemala City, GuatemalaDec 14, 1995 · N503U · DestroyedNTSB MIA96LA040Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.Dec 14, 1995 · N48959 · Substantial damageNTSB LAX96LA072Accident · No injuriesLimited investigationFinal reportCessna P210N · Grass Valley, CAthe failure of the pilot to follow the before starting engine checklist and ensure that the landing gear selector was in the down position, and the pilot's decision to takeoff with a known aircraft deficiency.Dec 14, 1995 · N4598K · Substantial damage