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 MIA92LA005Accident · No injuriesLimited investigationFinal reportBell 206-L-1 · Hollywood, FLThe failure of the pilot to maintain rotor RPM and the failure of the CFI to monitor the controls.NTSB LAX92LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Riverside, CAThe failure of a hydraulic gear return line, which caused the aircraft's main landing gear to collapse during landing touchdown.NTSB FTW92LA003Accident · No injuriesLimited investigationFinal reportBeech C-45H · Edinburg, TXPower loss due to a loss of oil pressure for undetermined reasons. A factor was the lack of suitable terrain for forced landing.NTSB ATL92LA003Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gadsden, ALFuel starvation due to incorrect fuel line installations, an inoperative fuel boost pump, and incorrect pilot procedure. A factor in this accident was the pilot's intentional operation with a known fuel system deficiency.NTSB ANC92LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Amber Bay, AKThe pilot's loss of directional control during the landing roll. Contributing to the accident was the unfavorable wind.NTSB MIA92FA004Accident · 1 fatalField investigationFinal reportAero Commander 100 · Carrabelle, FLThe non instrument-rated pilot-in-command's decision to continue flight into known instrument meteorological conditions (thunderstorm) and failure to maintain airspeed (vso) while maneuvering. Contributing to the accident was the pilot-in-command's failure to…NTSB LAX92LA008Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Flagstaff, AZAn inadvertent stall/mush due to the pilot's failure to maintain the appropriate airspeed during the takeoff attempt. Factors in the accident were the high density altitude and the inadequate preflight planning by the pilot.NTSB LAX92LA007Accident · No injuriesLimited investigationFinal reportCessna 421C · Santa Monica, CAThe failure of the pilot of the other aircraft to maintain an adequate visual lookout while taxiing his aircraft.NTSB LAX92LA006Accident · 2 fatalLimited investigationFinal reportBentley Mongoose A · Boulder City, NVThe pilot's selection of an inadequate takeoff area which was too short for the prevailing conditions.NTSB FTW92LA004Accident · No injuriesLimited investigationFinal reportCessna 210C · Leander, TXThe pilot's disregard for the hazardous weather advisories received. A factor was the weather.NTSB FTW92LA001Accident · Serious injuriesLimited investigationFinal reportBoeing 727-243 · Little Rock, ARThe pilot's failure to specifically warn the flight attendants of the hazardous conditions warnings. A factor was the turbulence.NTSB FTW92DPJ01Accident · 1 fatalFinal reportAyres S2R-T15 · Cordell, OKInadvertent stall. A factor was that the aircraft weight and balance limitations were exceeded.NTSB BFO92FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake Bay, MDUndetermined. The aircraft wreckage has not been located.NTSB SEA92FA001Accident · 1 fatalField investigationFinal reportNorth American Navion · Ola, IDAn incapacitating heart attack while in flight.NTSB NYC92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Auburn, METhe pilot was buzzing and stalled the airplane at too low an altitude to recover.NTSB MIA92LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Vieques, PRInadequate aircraft maintenance inspection resulting in the defective muffler which failed and caused an inflight fire.NTSB MIA92LA003Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Clewiston, FLThe pilot in command's failure to maintain adequate clearance while maneuvering resulting in an in flight collision with a guy wire.NTSB LAX92LA005Accident · No injuriesLimited investigationFinal reportRobinson R22B · Honolulu, HIThe improper use of the flight controls by the instructor pilot ND the failure to maintain proper rotor RPM.NTSB LAX92LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAThe failure of the student pilot to maintain control of the aircraft during a recovery from a bounced landing.NTSB FTW92LA005Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Dfw Airport, TXThe pilot's misjudgment of the wing tip clearance. A factor was the failure of the maintenance personnel to follow procedures and directives pertaining to taxiway and ramp clearance.NTSB FTW92LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Henryetta, OKLoss of engine power for an unknown reason.NTSB DEN92LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Erie, COThe pilot's failure to maintain directional control land his inadequate compensation for wind conditions. Factors were: crosswind conditions and the pilot's total lack of experience.NTSB ATL92LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sanford, NCThe loss of engine power due to unknown reasons.NTSB MIA92GA002Accident · 2 fatalFinal reportCessna 172K · Everglades City, FLThe pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.NTSB LAX92LA003Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Palo Alto, CAAn inflight los of control due to the failure of the student pilot to correctly configure the rudder trim for takeoff.NTSB ATL92LA001Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Cartersville, GAThe failure of the pilot to maintain control of the aircraft during the landing roll and the improper remedial action taken by the pilot to regain control of the airplane.NTSB ANC92FA002Accident · No injuriesField investigationFinal reportCessna 172M · Bethel, AKA power loss over unsuitable terrain which resulted in a nose over.NTSB DEN92LA001Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Evergreen, COIn flight encounter with a sudden downdraft. A factor was: the pilot's lack of total experience in aircraft type.NTSB CHI92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Taylor, MOThe pilot-in-command's failure to attain proper compensation for the crosswind. A factor contributing to the accident was the crosswind.NTSB ANC92IA001Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Fairbanks, AKIncorrect installation of crankshaft counterwweight rollers by the manufacturer during remanufacture of the engine. Factor was the inadequate surveillance of the engine assembly process by the manufacturer.NTSB SEA91LA259Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Granite Falls, WAThe pilot's decision to not perform a go-around and a misjudged distance.NTSB MIA92LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brooksville, FLThe pilot's inadvertent flight into IMC conditions, and his selection of unsuitable terrain for his attempted precautionary landing.NTSB LAX92T#A01Accident · No injuriesClass 3Final reportCessna L-19 · Tonopah, NVNTSB LAX92LA002Accident · No injuriesLimited investigationFinal reportCano Avid Flyer · Sonora, CAFuel starvation due to vapor lock.NTSB LAX92LA001Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Dunsmuir, CA1) Improper preflight planning by the aircraft owner, 2) failure of the owner to refuel the aircraft, 3) operation of the aircraft by the owner and a mechanic at a known fuel state below the minimum required for takeoff, and 4) failure of the mechanic to…NTSB ANC91LA156Accident · No injuriesLimited investigationFinal reportAeronca Sedan 15AC · Anchorage, AKFailure of the pilot to ensure that the fuel caps were secure, which restuled in a fuel leak and subsequent fuel exhaustion.NTSB SEA91FA258Accident · 2 fatalField investigationFinal reportCessna 182Q · Lincoln, MTThe improper inflight planning/decision by the pilot to continue VFR flight into IMC conditions. Factors relating to the accident were the mountainous terrain in the area, and the low ceilings and clouds obscuring the mountains.NTSB BFO91FA087Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Laurel, MDA loss of engine power for undetermined reasons.NTSB ATL91LA184Accident · 1 fatalLimited investigationFinal reportFischer Wagabond · Rossville, TNThe loss of engine power as a result of carburetor icing.NTSB SEA91FA255Accident · 3 fatalField investigationFinal reportLake LA-250 · Sisters, ORImproper planning/decision by the pilot(s), and failure to attain sufficient altitude to remain clear of obstructions. Factors related to the accident were: the pilot(s) failure to use all available runway, high density altitude, rising terrain and trees…NTSB NYC91LA253Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Manchester, NHThe pilot's failure to maintain control. A factor was the unforecasted strong cross winds.NTSB NYC91LA252Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Hadley, MAAn inflight loss of control due to entanglement of a prematurely deployed parachute in the elevator.NTSB NYC91LA251Accident · Minor injuriesLimited investigationFinal reportCessna C-152 II · Blue Bell, PAThe pilot failed to maintain directional control of the airplane, resulting in the airplane drifting to the left of the runway and impacting with a windsock pole. Contributing factors in the accident were the pilot's inadequate compensation for a crosswind…NTSB NYC91LA249Accident · No injuriesLimited investigationFinal reportDavis D1K · Chester, CTImproper maintenance on the engine which resulted in a power loss due to a stuck exhaust valve and subsequent forced landing in unsuitable terrain.NTSB NYC91LA248Accident · No injuriesLimited investigationFinal reportFairchild SW3 · Atlantic City, NJA failure of the down lock roller bearings of the right main landing gear, as the result of an improper modification.NTSB MIA91LA228Accident · Serious injuriesLimited investigationFinal reportAeronca 7EC · Moore Haven, FLThe pilot's diversion of attention and inattention to the airspeed resulting in the inadvertent stall mush. Contributing to the accident was inadequate altitude to recover.NTSB LAX91LA414Accident · No injuriesLimited investigationFinal reportLet L-13 · Adelanto, CAImproper planning/decision by the pilot. Loss of thermal lift was a related factor.NTSB LAX91LA413Accident · Minor injuriesLimited investigationFinal reportGrumman G164A-450 · Queen Creek, AZFailure of the engine cylinder, producing a loss of power. Contributing to the accident was the location of an irrigation ditch next to the landing area and a dark night light condition.NTSB CHI91DEV05Accident · No injuriesFinal reportUllman Vari Viggen · Greenville, ILImproper maintenance installation of the propeller.NTSB BFO91LA086Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Grayson, KYThe pilot's failure to maintain control of the aircraft during the attempted go-around.