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 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.NTSB FTW95LA010Accident · Minor injuriesLimited investigationFinal reportWinn RV-6A · Marble Falls, TXThe pilot's improper compensation for the wind conditions. A factor was the unfavorable winds.NTSB CHI95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carbondale, ILthe pilot's inadequate visual lookout, and improper altitude.NTSB 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.NTSB 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.NTSB ANC95LA001Accident · No injuriesLimited investigationFinal reportPiper J5C · Anchorage, AKThe loss of engine power for undetermined reasons and the lack of a suitable forced landing area.NTSB 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.NTSB 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.NTSB 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…NTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB SEA95LA001Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Billings, MTInadequate compensation for wind conditions. Factors to the accident were: crosswind and inadequate remedial action.NTSB FTW95LA007Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Houston, TXThe pilot's selection of unsuitable terrain.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ATL95LA002Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Covington, TNThe pilot's failure to maintain directional control during landing.NTSB ATL95LA001Accident · No injuriesLimited investigationFinal reportBeech V35B · Siler City, NCThe pilot's failure to maintain directional control during landing roll.NTSB 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.NTSB 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.NTSB FTW94LA319Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Lafayette, LAThe pilot's inadvertent gear retraction.NTSB FTW94LA318Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control.NTSB 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.NTSB 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.NTSB 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.NTSB FTW94IA321Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11-F · Anchorage, AKRight inboard flap vane component separation due to undetermined reasons.NTSB BFO94LA162Accident · No injuriesLimited investigationFinal reportChampion 7FC · Sacramento, KYThe pilot's failure to maintain adequate obstacle clearance.NTSB 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.NTSB 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.NTSB 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.NTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.NTSB 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.NTSB FTW94LA314Accident · No injuriesLimited investigationFinal reportCessna 182N · Cortez, COThe pilot's improper recovery from a bounced landing.NTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.NTSB 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.NTSB NYC94WA183Accident · 1 fatalForeign investigationBeech C35 · Lake Erie, CanadaNTSB LAX94LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Fullerton, CAFuel starvation due to improper fuel management.NTSB 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…NTSB 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.NTSB 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 ofNTSB 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.