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 FTW95LA373Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Broomfield, COThe pilot's attempt to taxi with a known inoperative brake. A factor was partial brake failure due to a leaking seal.NTSB SEA95LA200Accident · No injuriesLimited investigationFinal reportCessna 210 · Sunriver, ORThe failure of the landing gear hydraulic drive motor.NTSB SEA95LA197Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Spokane, WAthe pilot's failure to maintain airspeed while trying to clear a transmission wire. Factors include a transmission wire near the end of the takeoff area and glassy water.NTSB NYC95LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Andover, NJThe flight instructor's inadequate preflight which failed to detect an inadequate fuel supply which subsequently resulted in fuel exhaustion and the loss of engine power.NTSB LAX95LA317Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yuma, AZthe flight instructor's inadequate supervision of the flight and the failure of both pilots to maintain directional control.NTSB LAX95LA316Accident · No injuriesLimited investigationFinal reportCessna 172A · Weed, CAthe flight instructor's failure to maintain directional control of the aircraft.NTSB LAX95LA314Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Marana, AZthe pilot's poor installation of the propeller which allowed the propeller to become loose, and the pilot's improper emergency procedure by feathering the wrong propeller.NTSB LAX95FA313Accident · 2 fatalField investigationFinal reportBell 206-L1 · Johnsondale, CAthe pilot's failure to maintain an adequate obstacle clearance altitude while operating at a very low level. The aircraft's lack of wire cutters was a factor in this accident.NTSB BFO95LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Martinsburg, WVthe student pilot's failure to maintain control of the airplane during the landing/aborted landing sequence. A related factor is the student pilot's lack of total flight experience.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB LAX95LA312Accident · No injuriesLimited investigationFinal reportRobinson R-22 · El Monte, CAthe student's improper use of the cyclic control; the flight instructor's inadequate supervision of the flight; and the flight instructor's failure to maintain an adequate obstacle clearance distance in selection of a practice slope landing area.NTSB LAX95LA309Accident · No injuriesLimited investigationFinal reportJosephson MC-15 Cricket · San Diego, CAthe failure of the left engine due to inadequate maintenance of the ignition system.NTSB BFO95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Columbiana, OHThe improper maintenance installation and the subsequent separation of the torque links on the left main landing gear during the landing roll.NTSB ANC95LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's adequate compensate for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB NYC95WA219Accident · 6 fatalForeign investigationPiper PA-34-200T · Poznan, PolandNTSB NYC95LA218Accident · No injuriesLimited investigationFinal reportMarkwood BD-4 · Connellsville, PALoss of braking action at the right brake, due to a low level of hydraulic fluid and inadequate maintenance, which resulted in the loss of aircraft control.NTSB NYC95LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Richmond, RIThe pilot's mismanagement of the fuel supply, and his improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB MIA95LA217Accident · No injuriesLimited investigationFinal reportCessna 337D · Carthage, MSFailure of the normal brake system for undetermined reasons. Contributing to the accident was the failure of the pilot's seatback.NTSB MIA95LA215Accident · 1 fatalLimited investigationFinal reportBeech E-18S · Atlantic Ocean (Atlantic Ocean)Undetermined.NTSB LAX95LA315Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe pilot's selection of a runway inappropriate for the tailwind condition and his resultant failure to achieve a touchdown point which would allow the aircraft to stop prior to over running the departure end. The rough condition of the dirt runway, the lack…NTSB LAX95LA311Accident · Serious injuriesLimited investigationFinal reportElan Glaser Dirks DG-300 Elan · Truckee, CAthe pilot misjudged his planned approach by selecting a touchdown point close to the runway's approach end that did not provide sufficient clearance to safely maneuver when forcast turbulence and downdrafts were encountered. The pilot's early extension of…NTSB LAX95LA310Accident · No injuriesLimited investigationFinal reportBell 206BIII · Carmel Valley, CAthe pilot's failure to maintain an adequate clearance from obstructions while hovering.NTSB FTW95LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure by the pilot to properly plan his flight and check NOTAMS prior to departure. A factor was obstructions in the runway construction zone.NTSB FTW95LA361Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Holyoke, COthe pilot's failure to maintain terrain clearance.NTSB SEA95LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ogden, UTthe pilot's failure to use brakes to maintain directional control following a tailwheel steering malfunction. Partial failure of the tailwheel steering system contributed to the accident.NTSB LAX95LA308Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Ana, CAthe student's inadequate compensation for the existing crosswind condition, and his failure to raise the landing flaps and turn off the carburetor heat during the attempted go-around.NTSB FTW95LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was: a misreading or misunderstanding of the NOTAMS.NTSB FTW95LA368Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oklahoma City, OKThe failure of the low side of the turbine governor. A factor the lack of suitable terrain for the forced landing.NTSB FTW95LA367Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Whitesboro, TXThe pilot's improper flare, which resulted in a hard landing.NTSB FTW95LA365Accident · Serious injuriesLimited investigationFinal reportFunk, D.D. B-85C · Grants, NMa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA364Accident · Serious injuriesLimited investigationFinal reportIsaacson Kolb Twin Star MK II · Mansfield, TXthe loss of engine power for undertermined reasons, and the pilot's failure to maintain airspeed. A factor was the pilot's lack of flying experience.NTSB CHI95LA300Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Osage Beach, MOthe student pilot's misjudgement of distance and speed during the landing and failure to attain the proper touchdown point.NTSB ATL95LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kissimmee, FLThe inadequate visual lookout by the driver of the vehicle. A factor in the accident was the inoperative anti-collision lights of the aircraft.NTSB NYC95LA207Accident · 1 fatalLimited investigationFinal reportCessna 172M · Kingswood Twsp, NJFailure of the pilot to maintain control of the airplane, which resulted in an in-flight collision with trees.NTSB NYC95LA205Accident · No injuriesLimited investigationFinal reportCessna 172M · Williamson, NYthe loss of engine power and the eruption of a fire for undetermined reasons.NTSB NYC95FA203Accident · 5 fatalField investigationFinal reportCessna A185F · Block Island, RIthe pilot's failure to touch down a sufficient distance from shore, and his delay in aborting the landing. In addition, the pilot exceeded the airplane's weight and balance limits which reduced the airplane's performance.NTSB MIA95LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The failure of the oil lubrication system for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX95LA307Accident · No injuriesLimited investigationFinal reportCessna 182Q · Georgetown, CAthe pilot's inadequate compensation for the gusting crosswind conditions.NTSB LAX95LA306Accident · Serious injuriesLimited investigationFinal reportShort Lancair 320 · Rio Vista, CAthe failure of the wing flap actuator pushrod creating an asymmetrical flap condition during the landing flare maneuver. A contributing factor was the failure of the owner/builder to incorporate a manufacturer's design change for a stronger actuator pushrod.NTSB LAX95LA305Accident · No injuriesLimited investigationFinal reportSikorsky CH-54A · Emigrant Gap, CAa compressor stall in the right engine for an unknown reason, which resulted in a loss of power in that engine; and inadequate crew coordination between the pilot and copilot, which resulted in their failure to ensure that the external load was promptly…NTSB FTW95LA371Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot to execute the forced landing.NTSB FTW95FA363Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Wichita Falls, TXthe pilot's failure to maintain airspeed while diverting attention to an open cargo door. A factor was the pilot's inadequate preflight inspection.NTSB CHI95LA298Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Independence, MOthe pilot's failure to perform the pre-takeoff checklist and set the elevator trim tab to the takeoff position.NTSB CHI95LA297Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clarkston, MIthe pilot's failure to refuel.NTSB BFO95LA089Accident · No injuriesLimited investigationFinal reportCessna R172K · Lisbon, OHLoss of oil, where an oil filter adapter had separated from the crankcase cover, due to stripped threads that were caused or allowed by inadequate maintenance or inspection, which resulted in oil exhaustion and subsequent loss of engine power. A factor…NTSB BFO95LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Put-In-Bay, OHThe pilot's delay in aborting the landing after selecting the wrong runway. Factors relating to the accident were: garbled radio transmissions on the UNICOM frequency, and the resultant tailwind for landing.NTSB ANC95IA151Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Juneau, AKfailure and separation of the propeller blade due to foreign object damage and fatigue.NTSB ANC95FA150Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's improper in-flight planning and decision by flying into a box canyon.NTSB NYC95LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Orson, PAThe pilot's improper planning/decision, and his delay in aborting the takeoff, which resulted in a collision with a pile of dirt and shrubs. The upsloping terrain (for takeoff) was a factor.NTSB MIA95IA214Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Fort Lauderdale, FLLow electrical resistance of the autopilot aileron actuator for unspecified reasons which resulted in an uncommanded roll to the right.