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 SEA95LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Twisp, WAThe improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.NTSB SEA95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Anaconda, MTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain clearance from terrain.NTSB CHI95LA141Accident · Minor injuriesLimited investigationFinal reportSorrel SNS-4 · Menomonee Falls, WIthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the transmission wires.NTSB CHI95LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe pilot's failure to maintain directional control. A factor was the crosswind.NTSB CHI95IA142Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC10-10 · Chicago, ILfailure of the safety wire and/or safety wire lug arm on one of the stage one to two disk flange bolts due to an inadequate safetying method.NTSB MIA95LA124Accident · Minor injuriesLimited investigationFinal reportBubel, John A. Condor 2 · Homestead, FLLoss of engine power for undetermined reasons.NTSB LAX95LA176Accident · 1 fatalLimited investigationFinal reportKnapp Packard Special · Wheaton Springs, CAthe pilot's misjudged altitude and landing flare timing which resulted in a hard landing and nose over.NTSB LAX95LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Parker, AZthe failure and separation of the No. 2 cylinder exhaust valve. Darkness was a factor in the accident.NTSB FTW95FA184Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Porter, TXThe pilot's failure to identify the unsafe condition created by carrying a battery with jumper cables attached in the baggage compartment and the ensuing fire in the baggage compartment.NTSB CHI95LA139Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Kirksville, MOthe loss of engine power due to failure of the engine's hydraulic tappet body heads. Related factors in the accident were the restricted visual lookout, and the unsuitable terrain encountered during the forced landing.NTSB BFO95FA048Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Louisa, VAthe non-instrument rated private pilot's continued VFR flight into IMC and failure to maintain adequate altitude/clearance from terrain/obstacles. Related factors were the pilot's lack of total experience in IMC operations, his failure to obtain a preflight…NTSB ANC95LA051Accident · No injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's inadvertent water loop/swerve due to the use of improper landing procedures.NTSB SEA95LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Rice, WAThe pilot's failure to maintain the proper climb rate. A factor was trees in the flight path.NTSB MIA95LA123Accident · Serious injuriesLimited investigationFinal reportBeech B95 · Leakesville, MSThe failure of the pilot-in-command to operate the aircraft in accordance with manufacturer's limitations resulting in fuel starvation and a total loss of power in both engines.NTSB MIA95LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Clearwater, FLThe pilot-in-command's improper remedial action after the aircraft porpoised during the landing flare and touchdown.NTSB LAX95LA174Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Long Beach, CAthe pilot's misjudged landing flare. A factor in the accident was the illusion of a lower than actual altitude created by the high vegetation which led the pilot to flare early.NTSB FTW95LA185Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Morse, LAPower loss due to a cracked intake valve pipe assembly. A factor was the lack of suitable terrain for the forced landing.NTSB ATL95LA093Accident · Minor injuriesLimited investigationFinal reportLet L-23 Super Blanik · Spartanburg, SCThe pilot's inadvertent use speed brakes during takeoff.NTSB MIA95RA121Accident · 6 fatalForeign investigationDouglas DC-8F-54 · Guatemala Cty., GuatemalaNTSB LAX95LA179Accident · 1 fatalLimited investigationFinal reportCessna 152 · Palos Verdes, CAthat the pilot initiated the flight into known adverse weather, and inadvertent flight into instrument meteorological conditions.NTSB FTW95LA183Accident · No injuriesLimited investigationFinal reportCessna 340A · Dallas, TXThe pilot's failure to maintain aircraft control during landing. A factor was the loss of engine power for undetermined reasons.NTSB CHI95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boyceville, WIThe pilot's inadequate compensation for the wind conditions and subsequent failure to maintain runway alignment. The crosswind was a factor.NTSB CHI95IA342Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNinadequate design of the fly-by-wire flight control system which allowed false signals from the sidestick transducer units to generate uncommanded rolls.NTSB LAX95LA172Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 180A · Tucson, AZthe inability of the pilot to compensate for the wind conditions which resulted in the basket tipping over following touchdown during a high-wind landing.NTSB CHI95IA138Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Washington, DCthe pilot's excessive use of the flight controls during the landing approach, the company's disregard of information provided by the airplane manufacturer, and the company's failure to identify a potentially hazardous conditions based on the information…NTSB ATL95FA092Accident · 2 fatalField investigationFinal reportWittman O&O · Stevenson, ALAileron-wing flutter induced by separation at the trailing edge of an unbonded portion of wing fabric at an aileron wing station. The debonding of the wing fabric was a result of improper installation.NTSB NYC95LA095Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Robbinsville, NJLoss of engine for undetermined reasons.NTSB MIA95WA120Accident · Minor injuriesForeign investigationCessna 550 · Walkers Cay, BahamasNTSB MIA95LA129Accident · No injuriesLimited investigationFinal reportPitts S-2B · Naples, FLThe failure of the tail wheel landing gear system for undetermined reasons. This resulted in an on-ground loss of control on landing rollout, ground loop, and collapse of the right main landing gear.NTSB LAX95TA171Accident · No injuriesFinal reportBell 206-L4 · Thermal, CAThe CFI's failure to follow the flight manual procedures by using full up collective during an autorotation landing.NTSB CHI95TA151Accident · No injuriesFinal reportCessna 172 · Hutchinson, MNThe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the crosswind and soft terrain.NTSB CHI95LA137Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Dodge City, KSfatigue and subsequent catastrophic failure of the connecting rod originating from the decarburized area on the shank of the rod. Factors were the low cloud weather condition and the ditch.NTSB CHI95LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springfield, MOThe student pilot's failure to refuel the airplane. The student pilot's inadequate fuel consumption calculations were a related factor.NTSB ATL95LA091Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Huntsville, ALA loose wire which shorted between an exposed terminal on the avionics bus relay and the oil line to the oil pressure gage, and the failure of maintenance personnel to tie up loose wires.NTSB ATL95FA090Accident · 2 fatalField investigationFinal reportAxell, Charles Glasair RG-2 · Elberta, ALThe pilot's failure to maintain flying speed which resulted in a stall. A factor was the loss of engine power due to a blocked fuel injector nozzle.NTSB ANC95LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Old Harbor, AKThe pilot's continued flight into known adverse weather. The whiteout condition was a factor.NTSB NYC95LA094Accident · No injuriesLimited investigationFinal reportCessna 172G · Augusta, METhe student pilot's delay in aborting the landing attempt. The crosswind, and the pilot's inadequate compensation for the crosswind were factors.NTSB FTW95FA181Accident · 2 fatalField investigationFinal reportBell 47D1 · Ardmore, OKInflight collision with a power transmission array static line when the flight instructor and dual (private pilot) student failed to maintain adequate visual lookout.NTSB ATL95LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Payne, ALThe inaequate visual lookout by both pilots. Factors were the radio reception difficulties of the 152 pilot, his failure to make position reports while maneuvering for a landing, and the failure of the 182 pilot to have a safety observer while conducting…NTSB NYC95WA097Accident · 1 fatalForeign investigationCessna 172M · St. Johns, CanadaNTSB NYC95LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bangor, MEthe pilot's improper flare, which resulted in a hard landing and collapse of the right main gear.NTSB NYC95LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Cleveland, OHthe loss of engine power for undetermined reasons, and the pilot's improper decision to fly an extended landing pattern after experiencing a partial loss of engine power.NTSB MIA95WA118Accident · No injuriesForeign investigationCessna 501 · San Salvador, El SalvadorNTSB LAX95WA185Accident · No injuriesForeign investigationPiper PA-18 · Guerrero Negro, MexicoNTSB FTW95LA180Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Mcgehee, ARThe pilot intentionally shutting down the airplane's engine. A factor was the pilot's improper maintenance procedures.NTSB FTW95FA349Accident · 4 fatalField investigationFinal reportCessna 172D · Tsaile, AZThe pilot's failure to maintain terrain clearance. Factors were the pilot's lack of mountain flying experience and the rising terrain.NTSB CHI95LA135Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Napoleon, MIthe pilot's failure to retract the wing flaps prior to takeoff and the subsequent failure of the airplane to climb during takeoff.NTSB SEA95LA085Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Richfield, UTIce ingestion. Factors to the accident were: aircraft protective coverings were unavailable, inadequate preflight inspection, and uneven terrain.NTSB SEA95LA084Accident · No injuriesLimited investigationFinal reportBaxter-Wilson CW CHAMP-3 · Forks, WALoss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB NYC95LA096Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Clarion, PAA partial failure of the brake system.