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 LAX95FA003Accident · 1 fatalField investigationFinal reportAero Commander 560 · Essex, CAThe pilot's inadvertent flight into IMC conditions. Contributing to the accident was a loss of control of the aircraft and exceeding the structural limits of the aircraft. The weather conditions were factors.Oct 5, 1994 · N251VW · DestroyedNTSB FTW95LA010Accident · Minor injuriesLimited investigationFinal reportWinn RV-6A · Marble Falls, TXThe pilot's improper compensation for the wind conditions. A factor was the unfavorable winds.Oct 5, 1994 · N600CW · Substantial damageNTSB CHI95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carbondale, ILthe pilot's inadequate visual lookout, and improper altitude.Oct 5, 1994 · N66224 · Substantial damageNTSB ATL95LA004Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Ashburn, GAThe failure of a blade counterweight bearing shaft, allowing one propeller blade to go to high pitch.Oct 5, 1994 · N8971Q · Substantial damageNTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.Oct 4, 1994 · N3164X · Substantial damageNTSB ANC95LA001Accident · No injuriesLimited investigationFinal reportPiper J5C · Anchorage, AKThe loss of engine power for undetermined reasons and the lack of a suitable forced landing area.Oct 4, 1994 · N38532 · Substantial damageNTSB NYC95FA001Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Montgomery, NYwas the failure of the pilot to maintain adequate terrain clearance on final approach which resulted in a tree strike. Factors were the night conditions and the failure of the pilot to use the recommended runway.Oct 3, 1994 · N8397F · DestroyedNTSB MIA95LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · Stuart, FLThe improper rigging of the landing gear safety squat switch by other maintenance personnel. Contributing to the accident was the contamination of the gear squat switch with corrosion and water.Oct 3, 1994 · N701AM · Substantial damageNTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…Oct 3, 1994 · N65454 · Substantial damageNTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.Oct 3, 1994 · N6676K · Substantial damageNTSB FTW95FA008Accident · 3 fatalField investigationFinal reportCessna T337G · Milford, UTThe pilot's continued flight into adverse weather conditions, which resulted in airframe (structural) ice, a loss of control, and subsequent in-flight breakup of the airplane. A factor related to the accident was: the icing/weather condition.Oct 3, 1994 · N531J · DestroyedNTSB CHI95LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Decatur, ILthe failure of the roller springs in the freewheeling unit of the transmission which caused the unit to disengage.Oct 3, 1994 · N5193B · Substantial damageNTSB ATL95FA003Accident · 2 fatalField investigationFinal reportCessna 182L · Ft. Mcclellan, ALThe pilot's continued VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the low ceiling, fog, and drizzle weather conditions, and the mountainous terrain at the accident site.Oct 3, 1994 · N3499R · DestroyedNTSB LAX95LA001Accident · 1 fatalLimited investigationFinal reportCessna 170B · Ramona, CAthe noninstrument-rated pilot's failure to maintain aircraft control due to spatial disorientation after encountering instrument meteorological conditions after the pilot decided to takeoff in adverse weather conditions. A factor in the accident was the dark…Oct 2, 1994 · N170CT · DestroyedNTSB FTW95LA006Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Alamogordo, NMThe encountered turbulence. A factor was the lack of suitable terrain available for the forced landing.Oct 2, 1994 · N70792 · Substantial damageNTSB FTW95LA005Accident · No injuriesLimited investigationFinal reportCessna 150L · Booker, TXThe pilot's failure to maintain a proper glidepath resulting in a collision with an object. Factors were the dark night and the pilot's disregard for the lack of lights.Oct 2, 1994 · N16191 · Substantial damageNTSB FTW95FA004Accident · Minor injuriesField investigationFinal reportBeech 1900D · Denver, COThe captain's inaccurate evaluation of weather conditions, and his decision to fly into known adverse weather. A factor was the hail.Oct 2, 1994 · N31YV · Substantial damageNTSB CHI95FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Martinsville, INThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, and failure to maintain sufficient altitude/clearance above the ground.Oct 2, 1994 · N99305 · DestroyedNTSB CHI95FA001Accident · 1 fatalField investigationFinal reportCessna 150G · Lamberton, MNThe pilot's failure to maintain airspeed. A factor in the accident was the pilot's ostentatious display by buzzing.Oct 2, 1994 · N3654J · DestroyedNTSB SEA95LA001Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Billings, MTInadequate compensation for wind conditions. Factors to the accident were: crosswind and inadequate remedial action.Oct 1, 1994 · N664G · Substantial damageNTSB FTW95LA007Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Houston, TXThe pilot's selection of unsuitable terrain.Oct 1, 1994 · N5996X · Substantial damageNTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.Oct 1, 1994 · N732VK · DestroyedNTSB FTW95FA002Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Pagosa Springs, COThe pilot's continued flight into known adverse weather. Factors were the pilot's lack of familiarity with the geographic area, the turbulence and high density altitude.Oct 1, 1994 · N1480X · DestroyedNTSB FTW95FA001Accident · 1 fatalField investigationFinal reportMcmurtrie Jurca MJ-10 · Bartlesville, OKAn inadvertent pilot-induced stall at too low an altitude to effect a safe recovery. Factors were the malfunctioning propeller system and the uncommanded feathering of the propeller.Oct 1, 1994 · N379SF · DestroyedNTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.Oct 1, 1994 · N99600 · Substantial damageNTSB ATL95LA002Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Covington, TNThe pilot's failure to maintain directional control during landing.Oct 1, 1994 · N731PS · Substantial damageNTSB ATL95LA001Accident · No injuriesLimited investigationFinal reportBeech V35B · Siler City, NCThe pilot's failure to maintain directional control during landing roll.Oct 1, 1994 · N2890W · Substantial damageNTSB ANC95LA002Accident · No injuriesLimited investigationFinal reportCessna 180 · Aniak, AKThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the rough/uneven condition of the runway's surface.Oct 1, 1994 · N2707X · Substantial damageNTSB FTW94LA320Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Andrews, TXThe pilot's failure to initiate a go-around after encountering a tailwind. A factor was the tailwind.Sep 30, 1994 · N8901Y · Substantial damageNTSB FTW94LA319Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Lafayette, LAThe pilot's inadvertent gear retraction.Sep 30, 1994 · N6857C · Substantial damageNTSB FTW94LA318Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control.Sep 30, 1994 · N46872 · Substantial damageNTSB CHI94LA351Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · West Chicago, ILthe pilot's failure to use the manual hydraulic pump to lower the landing gear. Factors were the failure of the fuel selector handle, the subsequent fuel starvation, and the pilot's failure to properly crossfeed and restart the left engine.Sep 30, 1994 · N5272A · Substantial damageNTSB BFO94LA161Accident · 2 fatalLimited investigationFinal reportHenderson Christen Eagle II · Painesville, OHThe pilot's failure to maintain aircraft control while conducting aerobatic maneuvers. The pilot's overconfidence in his ability was a factor.Sep 30, 1994 · N39RH · DestroyedNTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.Sep 29, 1994 · N48572 · Substantial damageNTSB FTW94IA321Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11-F · Anchorage, AKRight inboard flap vane component separation due to undetermined reasons.Sep 29, 1994 · N603FE · Minor damageNTSB BFO94LA162Accident · No injuriesLimited investigationFinal reportChampion 7FC · Sacramento, KYThe pilot's failure to maintain adequate obstacle clearance.Sep 29, 1994 · N7695E · DestroyedNTSB ATL94LA180Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Ozark, ALThe failure of the engines' main bearings because of a lack of lubrication. A factor was the heavily wooded terrain.Sep 29, 1994 · N41870 · Substantial damageNTSB NYC94LA184Accident · Serious injuriesLimited investigationFinal reportCessna 180B · East Moriches, NYThe failure of the pedestrian to stay clear of the active runway. A factor was night conditions.Sep 28, 1994 · N5112E · No damageNTSB LAX94FA383Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 520N · Mesa, AZFailure of the chase helicopter pilot to maintain clearance from the lead helicopter during a night approach to land. Possible factors relating to the accident were: darkness, and inadequate radio coordination between flight crews of the two helicopters.Sep 28, 1994 · N520NT · 2 aircraft · DestroyedNTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.Sep 28, 1994 · N53844 · Substantial damageNTSB FTW94LA317Accident · No injuriesLimited investigationFinal reportCessna 172B · Poteau, OKThe loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.Sep 28, 1994 · N7617X · Substantial damageNTSB FTW94LA314Accident · No injuriesLimited investigationFinal reportCessna 182N · Cortez, COThe pilot's improper recovery from a bounced landing.Sep 28, 1994 · N9ZG · Substantial damageNTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.Sep 28, 1994 · N2504Q · DestroyedNTSB ATL94FA179Accident · 1 fatalField investigationFinal reportRobinson R-22B · Knightdale, NCDivergence of the main rotor from its normal plane of rotation for an undetermined reason(s) resulting in rotor blade contact with the tailcone.Sep 28, 1994 · N83112 · DestroyedNTSB NYC94WA183Accident · 1 fatalForeign investigationBeech C35 · Lake Erie, CanadaSep 27, 1994 · N8784A · DestroyedNTSB LAX94LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Fullerton, CAFuel starvation due to improper fuel management.Sep 27, 1994 · N8707P · DestroyedNTSB MIA94IA217Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe first officer's failure to maintain directional control on landing roll out due to improper use of brakes, resulting in the airplane veering off the runway, and subsequent on-ground collision with a runway light and sign. Contributing to the incident was…Sep 26, 1994 · N63PB · Minor damageNTSB LAX94LA379Accident · No injuriesLimited investigationFinal reportRockwell S2R · Visalia, CAthe pilot failed to maintain an adequate visual lookout and collided with power lines which resulted in an in-flight loss of control and subsequent collision with terrain.Sep 26, 1994 · N8874Q · DestroyedNTSB FTW94FA311Accident · 1 fatalField investigationFinal reportCessna T188C · Roscoe, TXThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was the pilot's lack ofSep 26, 1994 · N3106J · DestroyedNTSB CHI94DET02Accident · Minor injuriesFinal reportSimcox Sport Trainer · Laporte, INThe pilot's continued operation with a known power deficiency. The loss of engine power was a factor in the accident.Sep 26, 1994 · N6881M · Substantial damage