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 CHI95TA174Accident · No injuriesFinal reportCessna 180 · Orr, MNthe pilot's inadequate compensation for the crosswind weather condition. A factor was the crosswind.May 12, 1995 · N9336C · Substantial damageNTSB BFO95FA050Accident · 1 fatalField investigationFinal reportCessna 172F · Tappahanock, VAThe student pilot's misjudgment of distance/speed during the approach to land, and her failure to go around while there was still sufficient runway remaining. Factors related to the accident were: inadequate supervision by the flight instructor, the student's…May 12, 1995 · N5238F · DestroyedNTSB ANC95LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Chickaloon, AKThe fracture of the crankshaft resulting in separation of the propeller and propeller flange in-flight. A factor associated with the accident was the lack of suitable terrain for an emergency landing.May 12, 1995 · N4366B · Substantial damageNTSB SEA95LA098Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Vancouver, WACarburetor heat was not used and aircraft control was not maintained. Factors to the accident were: the flight instructor's diverted attention, and carburetor icing conditions.May 11, 1995 · N96202 · Substantial damageNTSB LAX95LA186Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Richvale, CAthe pilot's failure to maintain a glidepath adequate to avoid an obstacle, and his inadequate compensation for the wind.May 11, 1995 · N8507H · Substantial damageNTSB LAX95LA184Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Honolulu, HIthe pilot's attempted flight in close proximity to terrain under gusty wind conditions at an inadequate terrain clearance altitude.May 11, 1995 · N7768S · DestroyedNTSB LAX95LA183Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's inflight loss of control due to his delay in releasing the glider after the towed glider experienced an unplanned altitude gain on takeoff when it encountered a dust devil.May 11, 1995 · N7403Z · DestroyedNTSB CHI95FA149Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · North Loup, NEFailure to the student pilot to maintain control of the airplane during a forced landing, after experiencing fuel starvation due to fuel mismanagement. Factors relating to the accident were: inadequate oversight (supervision) by the flight instructor (CFI),…May 11, 1995 · N41329 · DestroyedNTSB BFO95LA052Accident · Serious injuriesLimited investigationFinal reportCurtiss-Wright P-40E · Phelps, NYLoss of engine power for undetermined reasons. A factor related to the accident was the lack of suitable terrain for the forced landing.May 11, 1995 · N940AK · Substantial damageNTSB SEA95LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Lamont, WAUndetermined loss of engine power and an inadequate autorotation.May 10, 1995 · N7443F · Substantial damageNTSB FTW95LA194Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Casa, ARThe pilot's failure to maintain obstacle clearance.May 10, 1995 · N34628 · Substantial damageNTSB SEA95LA096Accident · No injuriesLimited investigationFinal reportCessna A185F · Oroville, WAWater contamination in the fuel, and the pilot's inadequate preflight of the aircraft before flight. Factors related to the accident were: deteriorated seal(s) on the fuel tank cap(s), non-compliance with an airworthiness directive to prevent water leaking…May 9, 1995 · N1684R · Substantial damageNTSB NYC95FA105Accident · 2 fatalField investigationFinal reportBeech BE60 · Olney, ILThe pilot's improper IFR procedures by descending below the minimum descent altitude and not executing the published missed approach procedures. A factor in thE accident was the low overcast and fog conditions.May 9, 1995 · N81TS · DestroyedNTSB NYC95FA103Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Toano, VAThe pilot misjudged altitude and distance which resulted in an undershoot of the landing area and collision with water. Contributing factors are inadequate helipad lighting and a dark night light condition.May 9, 1995 · N8311A · Substantial damageNTSB LAX95LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAthe failure of the pilot to properly judge the landing flare, and his improper bounced landing recovery technique, which resulted in a landing gear collapse during a hard landing.May 9, 1995 · N39ES · Substantial damageNTSB NYC95DEI01Accident · 1 fatalFinal reportStaudacher S-600 · Wellington, OHloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall and collision with the ground.May 8, 1995 · N600RT · DestroyedNTSB ATL95LA095Accident · No injuriesLimited investigationFinal reportKolb Firestar II · Cumming, GAThe pilot/owner's failure to inspect the aircraft, which resulted in a loose spark plug lead. A factor was the rough terrain conditions at the landing area.May 8, 1995 · N47WH · Substantial damageNTSB ANC95LA050Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dillingham, AKThe pilot's inadequate preflight planning and preparation. Factors associated with the accident are: the dispatcher's decision to dispatch a multi-engined airplane to a short, soft airstrip, and inadequate company management oversight/surveillance.May 8, 1995 · N3588Z · Substantial damageNTSB ANC95FA073Accident · 2 fatalField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall. The pilot's failure to obtain a weather briefing and an encounter with turbulence were factors in the accident.May 8, 1995 · N825PK · DestroyedNTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.May 7, 1995 · N6895Q · Substantial damageNTSB SEA95FA095Accident · 6 fatalField investigationFinal reportCessna T210L · Milford, UTthe pilot's continued flight into known adverse weather (icing conditions), and his delay in executing a course reversal to exit those conditions, which resulted in airframe ice accumulation and loss of control. A factor was the icing conditions.May 7, 1995 · N2115S · DestroyedNTSB MIA95LA128Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Miami, FLInadequate supervision by the CFI for allowing the student to initiate initial flare and power recovery at 100 feet instead of 40 feet and 40 feet instead of 8-10 feet respectively. Additionally, failure of the CFI to comply with the FAA approved flight…May 7, 1995 · N2321X · Substantial damageNTSB LAX95LA181Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Colusa, CAthe pilot's selection of an inadequate en route cruise altitude for the aerial observation flight, and his failure to identify and stop an inadvertent descent while flying over flooded terrain at a very low altitude. Lack of pilot experience in low level…May 7, 1995 · N7358T · DestroyedNTSB LAX95LA180Accident · Serious injuriesLimited investigationFinal reportDavenport LONG-EZ · Los Angeles, CAfuel starvation due to a modification of the fuel system that rendered it incapable of maintaining adequate fuel pressure. The builder/pilot's lack of understanding of the fuel system was a factor in this accident.May 7, 1995 · N41BF · DestroyedNTSB FTW95LA193Accident · No injuriesLimited investigationFinal reportBeech F33A · Houston, TXThe pilot's inadequate compensation for the wind conditions. A factor was the crosswind.May 7, 1995 · N18413 · Substantial damageNTSB CHI95FA148Accident · 1 fatalField investigationFinal reportCessna 177B · Nappanee, INairplane control was not maintained by the pilot during the his turn to an emergency landing area. Factors associated with this accident were the pilot not complying with the manufacturer's mandatory service bulletin, and an excessive fuel flow caused by the…May 7, 1995 · N11372 · DestroyedNTSB SEA95LA092Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bliss, IDThe pilot's continued VFR flight into instrument meteorological conditions. Factors include low ceiling, rain and fog.May 6, 1995 · N3728N · DestroyedNTSB SEA95FA093Accident · 2 fatalField investigationFinal reportCessna 152 · Snoqualmie Pass, WAThe pilot's attempt to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance with the terrain.May 6, 1995 · N855DA · DestroyedNTSB NYC95LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Old Bridge, NJThe pilot misjudged the landing flare and improperly recovered from a bounced landing.May 6, 1995 · N8097F · Substantial damageNTSB FTW95WA227Accident · No injuriesForeign investigationCessna 550 · Soto Cano, HondurasMay 6, 1995 · N26496 · Substantial damageNTSB FTW95LA192Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Gerome, ARThe pilot's use of unsuitable terrain for landing.May 6, 1995 · N8025Y · Substantial damageNTSB FTW95LA191Accident · No injuriesLimited investigationFinal reportCessna 190 · Longmont, COFailure by the pilot-in command-to compensate for crosswind conditions.May 6, 1995 · N1505D · Substantial damageNTSB CHI95LA147Accident · No injuriesLimited investigationFinal reportCessna 172M · Brooklyn, MIFatigue failure of the left main landing gear. Factors relating to the accident were: the pilot's improper flare for landing, and soft terrain.May 6, 1995 · N9347H · Substantial damageNTSB ATL95LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Dayton, TNInstallation of an improper crankshaft oil seal which eventually separated from its seat resulting in excessive oil loss, and the pilot's improper inflight planning in that he did not allow sufficient time to lower the landing gear.May 6, 1995 · N4300Y · DestroyedNTSB MIA95LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · N. Miami Beach, FLInadequate annual inspection by maintenance personnel for failure to identify a hardened oil hose from the oil pump to the oil cooler inlet inside a protective fire sleeve. Additionally, unsuitable terrain encountered during the forced landing contributed to…May 5, 1995 · N3482W · Substantial damageNTSB MIA95LA126Accident · Serious injuriesLimited investigationFinal reportFocke-Wulf FWP 149D · St. Augustine, FLInadequate fuel management by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. Contributing to the accident was the unsuitable terrain encountered during the emergency descent for the forced landing.May 5, 1995 · N253FW · Substantial damageNTSB FTW95LA190Accident · Serious injuriesLimited investigationFinal reportGrunska Earl J Baby ACE D · Paris, ARThe pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the partial loss of power for undetermined reasons.May 5, 1995 · N689EG · Substantial damageNTSB FTW95LA189Accident · No injuriesLimited investigationFinal reportCessna 180 · Little Rock, ARThe pilot's failure to maintain directional control due to the excessive taxi speed.May 5, 1995 · N180JV · Substantial damageNTSB NYC95LA101Accident · No injuriesLimited investigationFinal reportBell 206B · Hamilton, MAthe pilot's improper decision to fly at night with a night vision deficiency, and his failure to maintain clearance with trees during takeoff, which resulted in an in-flight collision with the trees and the subsequent hard landing.May 4, 1995 · N219CT · Substantial damageNTSB NYC95LA100Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Middleboro, MAthe pilot's failure to maintain airspeed during a low altitude aerial application turn, which resulted in inadvertent settling with power and the subsequent collision with the terrain.May 4, 1995 · N444GW · Substantial damageNTSB FTW95TA187Accident · No injuriesFinal reportCessna 210J · Fabens, TXLoss of engine power due to water contamination of the fuel.May 4, 1995 · N2423S · Substantial damageNTSB FTW95RA188Accident · 7 fatalForeign investigationGrumman G-1159 · Quit0, EcuadorMay 4, 1995 · N409MANTSB ANC95LA052Accident · No injuriesLimited investigationFinal reportCessna 205 · Anchorage, AKA failure of the engine driven fuel pump. Factors in the accident were the pilots' inadequate in-flight planning and unsuitable terrain in the area of the forced landing.May 4, 1995 · N8312Z · DestroyedNTSB NYC95LA099Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Sea Bright, NJFailure of the position 19 engine bearing, which resulted in shifting of the accessory gear drive, disengagement of the fuel pump, fuel starvation, and loss of engine power.May 3, 1995 · N900PH · Substantial damageNTSB LAX95LA178Accident · No injuriesLimited investigationFinal reportGodkey Kitfox IV · Phoenix, AZthe failure of the ignition system due to a deffective diode.May 3, 1995 · N4357Q · Substantial damageNTSB NYC95LA098Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Columbus, OHthe pilot's inadequate preflight of the airplane's fuel quantity, resulting in a complete loss of engine power due to fuel exhaustion, and the subsequent night forced landing and collision with the terrain.May 2, 1995 · N4575S · Substantial damageNTSB LAX95LA177Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Red Bluff, CAthe separation of the throttle linkage due to improper installation, and the pilot's misjudgement of the glide path necessary to reach the runway prior to shutting down the engine.May 2, 1995 · N6636R · Substantial damageNTSB FTW95FA186Accident · 1 fatalField investigationFinal reportBell 206L-3 · Venice, LALoss of engine power due to ingestion of exhaust fumes from an oil platform flare boom.May 2, 1995 · N347AL · DestroyedNTSB CHI95LA145Accident · Minor injuriesLimited investigationFinal reportFranklin EAA BI-PLANE/P1 · Rockville, INthe pilot's improper maintenance installation and his inadvertent takeoff. A factor was the pilot's inadequate pre-flight planning.May 2, 1995 · N3428 · Substantial damageNTSB CHI95LA144Accident · No injuriesLimited investigationFinal reportQuad City Challenger · Bridgeport, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.May 2, 1995 · N100GB · Destroyed