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 SEA00FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Hermiston, ORThe pilot's failure to maintain clearance with terrain. Factors include a dark night, low ceilings and mist.Dec 23, 1999 · N8129R · DestroyedNTSB LAX00LA060Accident · No injuriesLimited investigationFinal reportPitts S-2B · Santa Ana, CAThe failure of the pilot of the other airplane to maintain an adequate obstruction clearance while taxiing.Dec 23, 1999 · N87WA · 2 aircraft · Minor damageNTSB FTW00WA056Accident · 2 fatalForeign investigationCessna 414 · Apodaca, MexicoDec 23, 1999 · XBEXF · DestroyedNTSB CHI00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Alexandria, MNThe pilot's inadequate inflight decision to continue flight into icing conditions. An additional cause was the directional control not maintained by the pilot. Contributing factors were the viewable area of the aircraft's heated windshield panel, in-flight…Dec 23, 1999 · N8417A · Substantial damageNTSB ATL00LA018Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Adjuntas, PRThe pilot continued flight into adverse weather conditions that included low ceiling and turbulence. Factors to the accident were trees.Dec 23, 1999 · N1315A · DestroyedNTSB ANC00LA020Accident · No injuriesLimited investigationFinal reportCessna 185 · Chenega Bay, AKThe pilot's selection of an unsuitable takeoff area during the incoming tide. Factors associated with the accident were the incoming tide wave, and the pressure induced by the delays encountered picking up the passengers.Dec 23, 1999 · N70021 · Substantial damageNTSB NYC00LA056Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Port Clinton, OHLoss of engine power caused by ice crystal blockage of the fuel system.Dec 22, 1999 · N1545M · Substantial damageNTSB NYC00FA058Accident · 1 fatalField investigationFinal reportCessna 172P · Leominster, MAThe student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…Dec 22, 1999 · N96273 · 2 aircraft · DestroyedNTSB MIA00FA058Accident · 2 fatalField investigationFinal reportAero Commander 500 · Georgetown, SCThe noninstrument-rated pilot's improper decision to attempt VFR flight into known instrument flight conditions, willful disregard of FAA Automated Flight Service Station weather forecast/weather observations, failure to maintain airspeed (VSO) while…Dec 22, 1999 · N6261B · DestroyedNTSB FTW00FA052Accident · 2 fatalField investigationFinal reportBeech D95A · Boyd, TXThe instructor pilot's inadvertent stall/spin.Dec 22, 1999 · N456E · Substantial damageNTSB DCA00RA017Accident · 4 fatalForeign investigationBoeing 747-200F · Stansted, United KingdomDec 22, 1999 · HL745NTSB ATL00FA017Accident · 1 fatalField investigationFinal reportCessna 551 · Cordele, GAThe pilot's failure to follow the published missed approach procedures, and to maintain proper altitude. Factors contributing to the severity of the accident were the low ceilings and trees.Dec 22, 1999 · N1218S · DestroyedNTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.Dec 21, 1999 · N6561X · Substantial damageNTSB DCA00WA016Accident · 18 fatalForeign investigationMcDonnell Douglas DC-10-30 · Guatemala City, GuatemalaDec 21, 1999 · FGTDI · DestroyedNTSB ATL00LA022Accident · No injuriesLimited investigationFinal reportCessna 172N · Melbourne, FLThe certified flight instructor's improper touchdown flare that resulted in a hard landing.Dec 21, 1999 · N8182E · Substantial damageNTSB NYC00FA057Accident · 1 fatalField investigationFinal reportCessna 152 · N. Stonington, CTThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the pilot's lack of recent flight experience.Dec 20, 1999 · N757NU · Substantial damageNTSB MIA00GA057Accident · Serious injuriesFinal reportHughes OH-6A · Fort Myers, FLimproper maintenance inspection of the helicopter by unknown maintenance personnel, resulting in a worn control rod bearing being continued in service, and subsequent separation, resulting in an in-flight loss of control and a crash.Dec 20, 1999 · N72LC · Substantial damageNTSB MIA00FA056Accident · 1 fatalField investigationFinal reportBeech E-90 · Beaufort, SCThe pilot-in-commands failure to maintain the appropriate altitude (minimum descent altitude) during an area surveillance radar (ASR) approach, resulting in an in-flight collision with swampy terrain. Contributing to the accident was the co-pilot's failure to…Dec 20, 1999 · N75CF · DestroyedNTSB NYC00LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Morristown, NJThe pilot's failure to obtain proper takeoff airspeed and his failure to follow published emergency procedures. Factors related to the accident were the pilot's inadequate preflight and water contamination of the fuel system.Dec 19, 1999 · N7397Y · Substantial damageNTSB MIA00LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Naples, FLThe pilot's improper fuel management and selection of an empty fuel tank (auxiliary) on approach for landing. This resulted in a total loss of engine power due to fuel starvation, forced landing, and subsequent in-flight collision with terrain.Dec 19, 1999 · N8469P · Substantial damageNTSB NYC00LA059Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Blacksburg, VAThe pilot in command's failure to recover from a bounced landing.Dec 18, 1999 · N1452L · Substantial damageNTSB MIA00LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCThe certified flight instructor (CFI) failure to maintain directional control on rough terrain on takeoff. This resulted in the airplane veering to the left, colliding with bushes after the airplane became airborne, and subsequent in-flight collision with…Dec 18, 1999 · N95775 · Substantial damageNTSB MIA00LA053Accident · 1 fatalLimited investigationFinal reportSwertfeger Velocity 173 Elite · Murfreesboro, TNThe failure of an unknown maintenance person to comply with an Airworthiness Directive (replace center body bellows seal assembly and tube bushings) and Service Bulletin (replace fuel diaphragm) resulting in an in-flight power loss due to an over rich…Dec 18, 1999 · N627KB · Substantial damageNTSB LAX00LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Shoshone, CAThe pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.Dec 18, 1999 · N34261 · Substantial damageNTSB LAX00LA052Accident · Minor injuriesLimited investigationFinal reportRhea KR-2 · Moreno Valley, CAAn undetected fuel leak from an improperly manufactured right tank into the internal wing spaces, which resulted in fuel exhaustion.Dec 18, 1999 · N77KR · Substantial damageNTSB FTW00LA049Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Worth, TXThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise.Dec 18, 1999 · N8250U · Substantial damageNTSB FTW00LA048Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Brownsboro, TXThe loss of tail rotor effectiveness as a result of tail rotor vortex ring state.Dec 18, 1999 · N575PF · Substantial damageNTSB FTW00FA046Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Edgewood, TXthe pilot's failure to maintain aircraft control during a forced landing which resulted in a stall/spin. Contributing factors were the failure of the engine driven fuel pump, the engine manufacturer's use of an inadequate fuel pump which was only intended for…Dec 18, 1999 · N80951 · Substantial damageNTSB DCA00WA014Accident · No injuriesForeign investigationMcDonnell Douglas DC-10-30F · Amsterdam, NetherlandsDec 18, 1999 · N800WR · Substantial damageNTSB NYC00LA054Accident · No injuriesLimited investigationFinal reportMooney 20J · New Milford, CTFailure of 3 of the 4 connecting rods for an undetermined reason.Dec 17, 1999 · N43TP · Substantial damageNTSB LAX00LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Concord, CAthe pilot's failure to use a checklist and remove the control gust lock.Dec 17, 1999 · N738UA · Substantial damageNTSB FTW00LA050Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXThe student pilot's failure to maintain control of the airplane during the landing roll.Dec 17, 1999 · N912JR · Substantial damageNTSB FTW00LA047Accident · Serious injuriesLimited investigationFinal reportBeech BE-95A · Big Lake, TXthe pilot-in-command's failure to maintain directional control of the airplane during the aborted landing. Contributing factors were the crosswind, turbulence, and the pilot's lack of total experience in the make and model of aircraft.Dec 17, 1999 · N991Q · DestroyedNTSB CHI00LA049Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Georgetown, INthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the gusty tailwind condition and the low altitude at which the helicopter was hovering.Dec 17, 1999 · N990JR · Substantial damageNTSB CHI00LA048Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hanover, MIfuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.Dec 17, 1999 · N5BB · Substantial damageNTSB CHI00LA047Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Indianapolis, INthe flight crew misjudged the clearance between their right wing and the radome of the parked aircraft. A factor associated with the accident was the ground handling contractor failed to identify the unsafe/hazardous condition that existed on the congested…Dec 17, 1999 · N995CF · Substantial damageNTSB ATL00FA016Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Geneva, ALThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.Dec 17, 1999 · N2215U · Substantial damageNTSB FTW00LA045Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXThe pilot's failure to maintain rotor rpm during takeoff, which resulted in a hard landing following the aborted takeoff.Dec 16, 1999 · N121CC · Substantial damageNTSB DEN00LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-31T1 · Santa Fe, NMThe pilot initiating lift off at an airspeed insufficient to maintain flight and retracting the landing gear prematurely resulting in a stall mush. A factor was the pilot incorrectly setting the elevator trim.Dec 16, 1999 · N919RD · Substantial damageNTSB DEN00LA029Accident · No injuriesLimited investigationFinal reportBeech N-35 · Englewood, COA forced landing on unsuitable terrain due a complete loss of power. A factor was the pilot inadvertently placing the fuel selector to the off position while executing the approach for landing checklist.Dec 16, 1999 · N9468Y · Substantial damageNTSB SEA00LA032Accident · No injuriesLimited investigationFinal reportCessna 140 · Helena, MTSeparation of the left main landing gear. Factors include inadequate preflight inspection by the pilot, and inadequate inspection at the time of annual inspection by maintenance personnel.Dec 15, 1999 · N2739N · Substantial damageNTSB NYC00LA052Accident · No injuriesLimited investigationFinal reportCessna P210N · Greenwood, DEthe failure of the pilot to use full power for takeoff, which resulted in not obtaining a positive rate of climb and the inadvertent collision with trees. A factor was the fog.Dec 15, 1999 · N450M · Substantial damageNTSB MIA00LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodville, FLThe pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.Dec 15, 1999 · N460TC · Substantial damageNTSB DEN00FA028Accident · No injuriesField investigationFinal reportHughes 369D · Peyton, COan uncontrolled touchdown following entry into a "out-of-ground effect" hover. Factors were loss of tail rotor effectiveness, and the pilot's lack of recent experience in kind of aircraft and total experience in type of aircraft.Dec 15, 1999 · N5190C · Substantial damageNTSB ATL00LA015Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Iuka, MSThe separation of the nicopress fitting allowing a release of the rudder cable resulting in a loss of control during landing roll. A factor was the manufacturer's use of an improperly calibrated crimping tool.Dec 15, 1999 · N4AN · Substantial damageNTSB FTW00LA044Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Elk City, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Dec 14, 1999 · N3359C · Substantial damageNTSB DEN00LA027Accident · No injuriesLimited investigationFinal reportCessna 182R · Farmington, NMThe pilot's inadequate preflight planning, and his improper inflight decision to not land and refuel, which resulted in fuel exhaustion.Dec 14, 1999 · N9616H · Substantial damageNTSB CHI00LA046Accident · No injuriesLimited investigationFinal reportCessna 150B · Omaha, NEThe pilots failure to use carburetor heat during takeoff in weather conducive for serious carburetor ice. Factors were the weather that was conducive for carburetor icing and the presence of the truck that the aircraft impacted.Dec 14, 1999 · N7339X · Substantial damageNTSB MIA00LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Fort Lauderdale, FLThe failure of the pilot to maintain minimum flying airspeed, (Vso) during takeoff following a partial loss of engine power resulting in the aircraft stalling, an uncontrolled descent, and collision with trees. A factor in the accident was the failure of the…Dec 13, 1999 · N21312 · Substantial damageNTSB CHI00WA045Accident · Serious injuriesForeign investigationBoeing 777-222 · London, United KingdomDec 13, 1999 · N786UA · No damage