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 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.NTSB SEA96FA034Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kapowsin, WAthe pilot's failure to maintain aircraft control and terrain clearance. Turbulence was a factor.NTSB 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.NTSB 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.NTSB CHI96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wheeling, ILthe pilot's misjudgment of the landing flare.NTSB 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.NTSB LAX96LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Bakersfield, CAthe pilot's improper aborted landing procedure which resulted in the aircraft stalling and impacting terrain.NTSB LAX96FA249Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Death Valley, CAthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions.NTSB 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…NTSB 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…NTSB MIA96WA054Accident · No injuriesForeign investigationDouglas DC-3 · Nassau, BahamasNTSB FTW96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Waller, TXthe pilot's failure to maintain obstacle clearance.NTSB 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.NTSB 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…NTSB DCA96RA020Accident · 160 fatalForeign investigationBoeing B757 · Buga, ColombiaNTSB 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.NTSB 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.NTSB 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.NTSB 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,…NTSB 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.NTSB ATL96LA025Accident · 1 fatalLimited investigationFinal reportMoravan Zlin Z50 LA · Springfield, TNthe pilot's failure to maintain control of the aircraft.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW96LA074Accident · No injuriesLimited investigationFinal reportBeech 200 · Ingleside, TXThe pilot's improper decision, while evading law enforcement personnel during an illegal/unauthorized operation.NTSB 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 operationNTSB 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.NTSB 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.NTSB SEA96FA031Accident · 1 fatalField investigationFinal reportCessna T210M · Netarts, ORa loss of control for undetermined reasons.NTSB 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.NTSB 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.NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.NTSB SEA96LA030Accident · No injuriesLimited investigationFinal reportCessna 170B · John Day, ORThe pilot's failure to maintain a proper glidepath.NTSB 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…NTSB MIA96LA045Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLThe pilot's failure to properly plan the flight.NTSB MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.NTSB 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…NTSB 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…NTSB CHI96LA058Accident · No injuriesLimited investigationFinal reportCessna 150B · Grant, MIthe pilot's selection of unsuitable terrain and the weak ice-covered runway.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB MIA96WA046Accident · 2 fatalForeign investigationAero Commander 1121 · Guatemala City, GuatemalaNTSB 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.NTSB 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.