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 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.May 21, 1991 · N172GA · Substantial damageNTSB NYC91LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Vergennes, VTThe pilot's excessive taxi speed, resulted in an on ground loss of control.May 21, 1991 · N9163Z · Substantial damageNTSB FTW91DPG09Accident · No injuriesFinal reportGrumman G-164A · Goodwin, ARPower loss due to failure of the number five cylinder assembly. A factor was the soft terrain.May 21, 1991 · N542D · Substantial damageNTSB CHI91LA174Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Overland Park, KSThe pilot's failure to maintain a proper descent rate during an approach for landing.May 21, 1991 · N4014R · No damageNTSB 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.May 21, 1991 · N2906Z · Substantial damageNTSB 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.May 21, 1991 · N87966 · DestroyedNTSB 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.May 20, 1991 · N3842N · DestroyedNTSB 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.May 20, 1991 · N107GH · Substantial damageNTSB 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.May 20, 1991 · N9135T · Substantial damageNTSB 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.May 20, 1991 · N49DB · DestroyedNTSB 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…May 20, 1991 · N9656T · DestroyedNTSB CHI91FA159Accident · 1 fatalField investigationFinal reportLuscombe 8E · Clinton, MIPhysical impairment of the pilot due to heart attack.May 20, 1991 · N333LR · Substantial damageNTSB 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.May 20, 1991 · N7507J · DestroyedNTSB 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.May 19, 1991 · N4019T · Substantial damageNTSB 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.May 19, 1991 · N73903 · DestroyedNTSB 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…May 19, 1991 · N6017E · Substantial damageNTSB 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.May 19, 1991 · N3182Z · Substantial damageNTSB 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.May 19, 1991 · N66266 · Substantial damageNTSB 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…May 18, 1991 · N7808P · DestroyedNTSB 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.May 18, 1991 · N10MY · Substantial damageNTSB 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.May 18, 1991 · N6507H · Substantial damageNTSB 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.May 18, 1991 · N117BT · Substantial damageNTSB 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.May 18, 1991 · N1019M · DestroyedNTSB 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.May 18, 1991 · N44623 · Substantial damageNTSB 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.May 18, 1991 · N6AL · Substantial damageNTSB 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.May 18, 1991 · N3549R · Substantial damageNTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.May 17, 1991 · N4664S · Substantial damageNTSB 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.May 17, 1991 · N5048D · Substantial damageNTSB LAX91LA217Accident · No injuriesLimited investigationFinal reportFarrington 18A · Long Beach, CAGround resonance remedial action not performed by the pilot.May 17, 1991 · N6126S · Substantial damageNTSB FTW91LA082Accident · No injuriesLimited investigationFinal reportCessna 210L · Marked Tree, ARThe failure of the engine piston and connecting rod. A factor was the wet landing area.May 17, 1991 · N29163 · Substantial damageNTSB FTW91DPG04Accident · No injuriesFinal reportGrumman G-164B · Vanndale, ARThe pilot's failure to verify his weight and balance. A factor was the soft terrain.May 17, 1991 · N8106K · DestroyedNTSB DEN91FA071Accident · 1 fatalField investigationFinal reportCessna 172M · Wray, COThe pilot intentionally buzzing and failure to maintain proper altitude.May 17, 1991 · N80077 · Substantial damageNTSB 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.May 17, 1991 · N4650G · DestroyedNTSB 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…May 17, 1991 · N42WE · Substantial damageNTSB 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.May 16, 1991 · N17127 · Substantial damageNTSB 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…May 16, 1991 · N6724T · Substantial damageNTSB 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.May 16, 1991 · N6583G · Substantial damageNTSB 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.May 16, 1991 · N49368 · Substantial damageNTSB 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.May 16, 1991 · N9435Q · DestroyedNTSB DEN91LA074Accident · No injuriesLimited investigationFinal reportPitts S-2B · Albuquerque, NMFailure of the pilot of the other airplane to maintain visual lookout.May 16, 1991 · N603SB · 2 aircraft · Minor damageNTSB ATL91LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greensboro, NCA failure of the left magneto grounding lead resulting in a 'hot magneto' condition.May 16, 1991 · N2314Y · Substantial damageNTSB 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.May 15, 1991 · N94512 · Substantial damageNTSB 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.May 15, 1991 · N2619B · DestroyedNTSB MIA91LA147Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA momentary loss of engine power due to undetermined reasons.May 15, 1991 · N32133 · Substantial damageNTSB MIA91LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe pilot's selection of the wrong runway for wind conditions.May 15, 1991 · N83021 · Substantial damageNTSB FTW91FA092Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Parkin, ARFailure of the pilot to maintain adequate clearance from objects.May 15, 1991 · N4010P · DestroyedNTSB 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.May 15, 1991 · N6732C · DestroyedNTSB 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…May 15, 1991 · N882AA · Minor damageNTSB 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.May 14, 1991 · N8792H · DestroyedNTSB SEA91LA104Accident · No injuriesLimited investigationFinal reportHughes 269B · Grand Ronde, ORThe pilot inadvertently interfered with the controls.May 14, 1991 · N9506F · Substantial damage