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 CHI92LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Langdon, NDFailure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.NTSB BFO92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Manville, NJThe pilot's failure to maintain obstacle clearance.NTSB ANC92LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe left main landing gear ski being partially disconnected at the time of the landing. Contributing factors were the inadequate preflight by the pilot, and the snow covered landing area.NTSB ANC92LA048Accident · Minor injuriesLimited investigationFinal reportGerald G. Holland Challenger II · Fairbanks, AKExcessive taxispeed and directional control was not maintained. Factors to the accident were: lack of familiarization with aircraft and inadequate airspeed.NTSB LAX92LA144Accident · No injuriesLimited investigationFinal reportPiper PA28-235 · Havasu Lake, CAThe dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.NTSB SEA92LA063Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Eugene, ORAn improper fuel boost pump selector position, and incorrect procedures. Factors include an improper fuel tank selector position, and fuel starvation.NTSB FTW92LA093Accident · Serious injuriesLimited investigationFinal reportBoeing A-75N1 · Edna, TXThe pilot's failure to maintain control of the airplane and the subsequent stall. A factor was the pilot's diversion of attention.NTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.NTSB BFO92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Brewer, METhe pilot's failure to correct an excessive descent rate during flare. Contributing to the accident was the pilots improper compensation for wind conditions.NTSB BFO92IA046Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Louisville, KYInadequate obstacle clearance, which resulted in on ground collision with a blast fence. Contributing was inadequate instruction from ground personnel.NTSB BFO92FA044Accident · 2 fatalField investigationFinal reportCessna 172P · Accokeek, MDThe pilot experienced spatial disorientation which resulted in loss of control of the airplane.NTSB ATL92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Kennesaw, GAThe dual student's inadequate compensation for wind conditions and inadequate supervision by the flight instructor. Factors were: wind gusts, wind shear and turbulence.NTSB MIA92IA100Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe total failure of the main landing gear uplock and sequencing valve for undetermined reasons.NTSB FTW92LA094Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe loss of engine power due to rocker arm failure. A factor was the unsuitable terrain.NTSB DEN92LA043Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COUndetermined.NTSB ATL92LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Hull, GAThe pilot's inadequate preflight and inflight planning, which resulted in fuel exhaustion, and his failure to obtain a proper touchdown point, which resulted in a long landing and collision with terrain.NTSB BFO92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Stevensville, MDThe certificated flight instructor's (cfi's) inadequate supervision during the simulated emergency landing. Soft terrain in the touchdown area was a related factor.NTSB SEA92LA062Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Elbe, WAFuel starvation, improper fuel, improper aircraft servicing (fueling), and clearance not possible. Factors contributing to the accident were: no suitable terrain, low ceilings, dusk and trees.NTSB SEA92FA061Accident · 1 fatalField investigationFinal reportErcoupe 415-D · Winthrop, WAThe student pilot's alcoholic impairment of efficiency and judgement resulting in his failure to maintain airspeed during a go-around.NTSB MIA92LA098Accident · No injuriesLimited investigationFinal reportMooney M20K · St. Augustine, FLThe separation of the swage between the throttle outer housing and throttle cable resulting in loss of throttle control and the engine reducing to idle power.NTSB MIA92FA099Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Aberdeen, MSThe pilot-in-command's decision to initiate a turn back to the airport at a low altitude following loss of engine power.NTSB LAX92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Austin, NVThe pilot's loss of control due to the failure of his control wheel during an attempted go around.NTSB LAX92LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Yucapia, CAThe partial loss of power most likely related to the poor quality of aircraft maintenance. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB LAX92FA141Accident · 2 fatalField investigationFinal reportMooney M20C · Redding, CAA loss of engine power due to carburetor and air filter icing, and, the pilots decision to attempt flight into known adverse weather/icing conditions.NTSB FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.NTSB FTW92LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roanoke, LAThe locking of the main landing gear brakes.NTSB FTW92LA089Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Wright, ARThe failure of the pilot to maintain altitude due to diverted attention.NTSB DEN92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Longmont, COThe pilot's failure to maintain directional control during landing. Factors were: a snow bank alongside the runway, and gusty crosswind.NTSB BFO92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Doylestown, PAFailure of the pilot to maintain directional control during touchdown, which resulted in an inadvertent ground swerve. A factor related to the accident was the gusty crosswind condition.NTSB ATL92LA068Accident · 1 fatalLimited investigationFinal reportMaxair 582 · Willacoochee, GAThe pilot's failure to maintain flying speed which resulted in a loss of flight control, and an inadvertent stall.NTSB ATL92LA064Accident · No injuriesLimited investigationFinal reportKolb Mark III · Titus, ALThe manufacturer's failure to install the main fuel line properly which resulted in fuel starvation and a loss of engine power.NTSB SEA92LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Vancouver, WAThe pilot's failure to maintain the proper rate of descent.NTSB SEA92LA059Accident · No injuriesLimited investigationFinal reportCessna 172G · Billings, MTThe pilot's failure to maintain directional control. A factor was the crosswind.NTSB CHI92LA108Accident · No injuriesLimited investigationFinal reportCessna 150 · Waseca, MNDirectional control was not maintained by the pilot.NTSB CHI92DCJ02Accident · 2 fatalFinal reportExtra Flugzeugbau 300 · Grant, NEThe pilot's inadequate aircraft control while performing aerobatic maneuvers.NTSB ATL92LA063Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mt. Pleasant, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.NTSB ANC92LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · Juneau, AKThe pilot failed to maintain directional control during the landing roll.NTSB LAX92LA142Accident · No injuriesLimited investigationFinal reportCessna A188B · Corcoran, CAThe aircraft's encounter during the takeoff with a crosswind gust beyond the capability of the aircraft.NTSB CHI92LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Munising, MIThe inadequate maintenance inspection to remove water from the fuel system, and the pilot's inadequate preflight inspection.NTSB CHI92LA111Accident · No injuriesLimited investigationFinal reportCessna 177B · Olney, ILThe pilot's failure to select carburetor heat in a timely manner, and the total loss of engine power due to carburetor ice. Related factors are carburetor icing conditions, reduced visibilities in snow, low ceilings, the dark night, and soft terrain…NTSB BFO92LA040Accident · No injuriesLimited investigationFinal reportCessna 180C · Clarence, NYThe pilot's inadequate inflight decision to land with a defective ski landing gear on unsuitable terrain, which resulted in a nose over.NTSB BFO92LA039Accident · No injuriesLimited investigationFinal reportLet L-13 · Lock Haven, PAA tow rope that broke at low altitude.NTSB BFO92FA038Accident · 2 fatalField investigationFinal reportCessna 182A · Norfolk, VAThe loss of engine power for undetermined reasons.NTSB BFO92LA036Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S2B · Schellsburg, PAThe total blockage of the oil breather line causing excessive pressure in the engine, resulting in oil leakage and subsequent engine failure.NTSB ATL92LA062Accident · Minor injuriesLimited investigationFinal reportWilliam D. Weeks Glasair I · Timmonsville, SCThe improper selection of the fuel sector valve to the off position by the pilot.NTSB LAX92LA138Accident · No injuriesLimited investigationFinal reportCessna 340A · Long Beach, CAThe fatigue failure of the left main landing gear down lock bell crank pivot bolt.NTSB BFO92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Lynchburg, VAThe pilot's poor in-flight decision making resulting in fuel exhaustion. Contributing to the accident was the pilot's overall lack of experience.NTSB ATL92LA061Accident · No injuriesLimited investigationFinal reportCessna 150M · Jesup, GAThe failure of the pilot to properly compensate for the crosswind resulting in failure to maintain directional control during landing. A factor was the crosswind condition.NTSB ATL92FA060Accident · 2 fatalField investigationFinal reportBritish Aerospace BAE-3101 · Alcoa, TNThe pilot's failure to use the airplane checklist which resulted in a gear up landing; and the pilot's failure to maintain flying speed which resulted in an uncontrolled collision with the ground.NTSB MIA92LA096Accident · 2 fatalLimited investigationFinal reportAnkerman, Donald L. SX300 · Okeechobee, FLFailure of the pilot-in-command to maintain airspeed (vs) resulting in inadvertent stall/mush.