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 SEA91LA112Accident · No injuriesLimited investigationFinal reportCessna 172P · Alva, WYThe pilot's overconfidence in his personal ability, overconfidence in the aircraft's ability. Contributing to the accident was the engine failure.NTSB NYC91LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Vergennes, VTThe pilot's excessive taxi speed, resulted in an on ground loss of control.NTSB FTW91DPG09Accident · No injuriesFinal reportGrumman G-164A · Goodwin, ARPower loss due to failure of the number five cylinder assembly. A factor was the soft terrain.NTSB CHI91LA174Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Overland Park, KSThe pilot's failure to maintain a proper descent rate during an approach for landing.NTSB CHI91LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Mankato, MNPartial loss of engine power due to an unlocked engine primer. Factors related to the accident were that the pre takeoff check list was not followed by the pilot and the lack of suitable terrain for the forced landing.NTSB ANC91LA058Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Dog Fish Bay, AKThe pilot's exceeding the gross weight of the aircraft and inadequate supervision by company management. Contributing to the accident was the high vegetation.NTSB SEA91FA110Accident · 1 fatalField investigationFinal reportBeech 35 · Harrison, IDImproper preflight planning/preparation by the pilot. The terrain condition and the pilot's lack of total experience were related factors.NTSB NYC91DGT04Accident · No injuriesFinal reportGeorge E Heide, JR. Moni Motorglider · Annville, PAThe pilot's intentional landing on unsuitable terrain due to a loss of altitude precipitated by a downdraft.NTSB LAX91LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAFuel starvation due to the flight instructor's improper use of the fuel selector valve and his failure to properly supervise the conduct of the flight.NTSB LAX91LA220Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Gasquet, CAThe pilot's decision to attempt VFR flight in a narrow mountain valley in conditions of low ceilings and mountain obscurement.NTSB CHI91FA160Accident · 1 fatalField investigationFinal reportCessna 210 · Belleville, MIFailure of the engine driven fuel pump, the failure of the pilot to activate the electric auxiliary fuel pump, poor inflight decision, and poor execution of emergency procedures. A factor relating to the accident is the pilot's lack of experience in this…NTSB CHI91FA159Accident · 1 fatalField investigationFinal reportLuscombe 8E · Clinton, MIPhysical impairment of the pilot due to heart attack.NTSB ATL91LA096Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Rock Hill, SCThe pilot diverted his attention to a poisonous snake in the cockpit and failed to maintain control of the aircraft.NTSB SEA91LA113Accident · No injuriesLimited investigationFinal reportBeech B23 · Spanish Fork, UTThe pilot did not adequately recover from a bounced landing. Factors to the accident were: a poorly planned approach, and the pilot's lack of total flight experience.NTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.NTSB LAX91FA219Accident · Serious injuriesField investigationFinal reportBeech C23 · Cibola, AZThe pilot's failure to maintain adequate clearance between the aircraft and ground vehicle during a low pass resulting in an in flight collision with the vehicle, loss of control, and in flight collision with terrain. Factors related to the accident was the…NTSB DEN91LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Elbert, COThe pilot's delay in compensating for wind conditions. Factors were: high winds and a crosswind.NTSB CHI91LA158Accident · No injuriesLimited investigationFinal reportCessna 180 · Scottsbluff, NEFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident were a crosswind condition and lack of total experience in type of aircraft by the pilot.NTSB NYC91FA136Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Ravenna, OHFailure of the instructor pilot (CFI) to assure that adequate airspeed was maintained, after maneuvering (turning) for spacing behind another aircraft, which resulted in an inadvertent stall/mush. Factors related to the accident were: the improperly planned…NTSB MIA91LA148Accident · No injuriesLimited investigationFinal reportHughes 269C · Tarpon Springs, FLDelay by the pilot-in-command to apply adequate throttle & collective during transition off a dock for a takeoff over a lake. Contributing to the accident was his lack of total experience in the type operation.NTSB LAX91LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Richmond, CALoss of engine power due to carburetor ice. A factor in the accident was the failure of the instructor to properly supervise the conduct of the flight.NTSB FTW91LA083Accident · No injuriesLimited investigationFinal reportAustralite Aerobat FPP1 · Odessa, TXFuel starvation as a result of a cracked fuel line inside the fuel cell. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91FA081Accident · 2 fatalField investigationFinal reportCessna 150J · Caney, OKBinding of the #2 exhaust valve (stuck valve), and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. A factor related to the accident was: the failed exhaust manifold gasket.NTSB DEN91LA073Accident · No injuriesLimited investigationFinal reportBeech D18-S · Englewood, COThe loss of directional control by the pilot. Factors were: the cross, failure of the pilot to lock the tail wheel, and the pilot's disregard of crosswind limitations.NTSB DEN91FA072Accident · Serious injuriesField investigationFinal reportBeech C23 · Boulder, COInadvertent stall/mush due to the passengers's delay in relinquishing aircraft control, and inadequate supervision of the flight by the pilot in command. Factors were: mixture not leaned, and a high density altitude takeoff with a slight quartering tailwind.NTSB ATL91LA097Accident · No injuriesLimited investigationFinal reportBeech 23 · Dothan, ALThe failure of the cylinder head because of previous overheated operations. Factors in the accident were the pilot's inaccurate approach which resulted in the loss of directional control and subsequent swerve into the fence.NTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.NTSB SEA91LA107Accident · No injuriesLimited investigationFinal reportCessna 182A · Mead, WACarburetor ice and the pilot not using the carburetor hear. Factors to the accident were: carburetor icing conditions, and the pilot did not adequately evaluate the weather conditions.NTSB LAX91LA217Accident · No injuriesLimited investigationFinal reportFarrington 18A · Long Beach, CAGround resonance remedial action not performed by the pilot.NTSB FTW91LA082Accident · No injuriesLimited investigationFinal reportCessna 210L · Marked Tree, ARThe failure of the engine piston and connecting rod. A factor was the wet landing area.NTSB FTW91DPG04Accident · No injuriesFinal reportGrumman G-164B · Vanndale, ARThe pilot's failure to verify his weight and balance. A factor was the soft terrain.NTSB DEN91FA071Accident · 1 fatalField investigationFinal reportCessna 172M · Wray, COThe pilot intentionally buzzing and failure to maintain proper altitude.NTSB BFO91FA049Accident · 1 fatalField investigationFinal reportCessna 172N · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance. Contributing was mountainous terrain, low clouds, and VFR flight into IMC.NTSB ATL91LA095Accident · No injuriesLimited investigationFinal reportBeech 55 · Perry, GAImproper in-flight planning/decision by the pilot in command (CFI). The improper procedure of turning the fuel selector valve to 'off' at altitude to simulate a failed engine, then delaying restarting of the engine until the aircraft was on final approach was…NTSB SEA91LA108Accident · No injuriesLimited investigationFinal reportLee Bede BD-4 · Elma, WAThe pilot did not maintain an adequate airspeed. Factors to the accident were: proper alignment was not maintained, inadequate remedial action, and the pilot did not identify a stall.NTSB SEA91LA106Accident · No injuriesLimited investigationFinal reportBeech A36 · Rawlins, WYThe pilot's lack of familiarity with the aircraft, his lack of understanding of the electrical system, and a premature precautionary landing. Contributing to the accident were an alternator failure and the resultant false readings of the powerplant…NTSB LAX91LA216Accident · No injuriesLimited investigationFinal reportCessna C-150L · Groveland, CAThe pilots neglect to calculate the aircrafts fuel consumption and his failure to service the aircraft with fuel prior to the last takeoff. The wire across the aircrafts flight path during the forced landing was a factor in the accident.NTSB LAX91LA215Accident · No injuriesLimited investigationFinal reportTaylorcraft DC12-D · Las Vegas, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilot's lack of total experience in this type of aircraft.NTSB FTW91FA080Accident · 4 fatalField investigationFinal reportBeech V35B · Manor, TXThe pilot's operation of the aircraft at a gross weight and center of gravity which exceeded the certificated operating limitations, resulting in loss of control and structural overload. Turbulence was a related factor.NTSB DEN91LA074Accident · No injuriesLimited investigationFinal reportPitts S-2B · Albuquerque, NMFailure of the pilot of the other airplane to maintain visual lookout.NTSB ATL91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greensboro, NCA failure of the left magneto grounding lead resulting in a 'hot magneto' condition.NTSB NYC91LA135Accident · No injuriesLimited investigationFinal reportCessna 152 II · Newtonville, NJPilot factor in that the student pilot delayed asking for assistance, after becoming lost until insufficient fuel was available to make an airport. This resulted in engine failure to fuel exhaustion and a subsequent emergency landing in rough terrain.NTSB NYC91DGT03Accident · Serious injuriesFinal reportBell 47-G3B1 · Hughesville, PAThe loss of engine power for undetermined reasons and the pilot's selection of the forced landing area.NTSB MIA91LA147Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA momentary loss of engine power due to undetermined reasons.NTSB MIA91LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe pilot's selection of the wrong runway for wind conditions.NTSB FTW91FA092Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Parkin, ARFailure of the pilot to maintain adequate clearance from objects.NTSB FTW91FA078Accident · 2 fatalField investigationFinal reportBeech A36 · Caldwell, TXThe pilot-in-command's failure to properly position the fuel selector handle resulting in a fuel starvation power loss. A factor was the inadvertent stall.NTSB ATL91IA094Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Nashville, TNThe captain's failure to maintain a proper glide path after disconnection of the autopilot during the final approach. Factors in this accident were: the captain's failure to follow company procedures for category ii approaches, the first officer's failure to…NTSB SEA91LA105Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Lapwai, IDThe pilot's misjudgment of an aerial application swath run. Factors include a downdraft condition and soft terrain.NTSB SEA91LA104Accident · No injuriesLimited investigationFinal reportHughes 269B · Grand Ronde, ORThe pilot inadvertently interfered with the controls.