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 FTW92LA181Accident · No injuriesLimited investigationFinal reportCessna 120 · Reserve, LAThe loss of engine power due to the valve failure. A factor was the lack of suitable terrain for the forced landing.NTSB BFO92LA104Accident · No injuriesLimited investigationFinal reportCessna 172K · Piqua, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB BFO92LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pikesville, KYThe pilot's failure to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's improper flare. And objects near the runway.NTSB LAX92LA304Accident · No injuriesLimited investigationFinal reportCessna 182Q · Montague, CAThe pilot failure to maintain directional control.NTSB LAX92LA303Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Simi Valley, CAThe company's maintenace personnel improper adjustment of the aircraft's idle RPM and the failure of the instructor pilot to maintain adequate rotor RPM after the engine failed. The instructor pilot's lack of total experience in type of operation is a factor…NTSB LAX92LA302Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Ukiah, CAThe pilot's failure to maintain directional control of the aircraft during the aborted landing and initial climb-out. The pilot's improper landing flare, the inadvertent porpoise, and his improper recovery from a bounced landing were factors in the accident.NTSB LAX92IA307Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAA failure of ground personnel to ensure proper clearance between a taxiing airplane and an adjacent parked airplane. Contributing to the accident was a failure of ground personnel to properly position a parked airplane to ensure that it did not encroach into…NTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.NTSB CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.NTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.NTSB LAX92LA301Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Fresno, CAThe cfi's poor in-flight decision to proceed over the trees instead of the previously performed right circling turns and both pilots inadequate visual look-out. Contributing to this accident were the trees that partially obstructed the view of the power line…NTSB FTW92FA180Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Tool, TXThe pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.NTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.NTSB ATL92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Shallotte, NCThe deterioration of the left main fuel bladder which resulted in the premature exhaustion of the fuel supply and the loss of engine power. A factor was soft terrain.NTSB SEA92LA156Accident · Minor injuriesLimited investigationFinal reportThomsen, Horst Rotorway "EXEC" · Quilcene, WAA misjudged descent rate, and delayed corrective action. Factors include a lack of experience in this type of aircraft, and a building near the landing area.NTSB LAX92LA300Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Five Points, CAThe failure of airport personnel to perform the necessary runway maintenance. Contributing to this accident was the dark night and high vegetation.NTSB LAX92LA299Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Shafter, CAThe pic's poor preflight planning and the pic's and flight instructor/passenger's failure to use the emergency checklist. The loss of engine power due to fuel starvation was a factor in the accident.NTSB LAX92LA298Accident · No injuriesLimited investigationFinal reportCessna 150L · Pittsburg, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. The rough/uneven terrain is a factor in this accident.NTSB FTW92LA186Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gould, ARThe aircraft crosswind landing capability was exceeded. A factor was the the gusting crosswind.NTSB BFO92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dayton, OHAn encounter with a strong wind gust which resulted in loss of control and nose over.NTSB ANC92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's improper preflight planning/decision, and his delayed aborted takeoff. Contributing was the pilot's failure to use the airplane performance data.NTSB FTW92IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Oklahoma City, OKHydraulic fluid exhaustion due to the chafed 'a' system hydraulic line and the improper installation by unknown maintenance personnel of the 'b' system line.NTSB FTW92DPG09Accident · Serious injuriesFinal reportAir Tractor AT-301A · Fisher, ARA loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed above a stall.NTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.NTSB BFO92LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Southwick, MAImproper adjustment of the stabilizer control system by maintenance personnel.NTSB ATL92FA139Accident · 2 fatalField investigationFinal reportBeech 58P · Greenville, GAContinued flight by the pilot into an area of known adverse weather, and his failure to maintain control of the aircraft, which resulted in exceeding the design stress limits of the plane and overload failure of the stabilizers and wings. The adverse weather…NTSB ATL92FA138Accident · 2 fatalField investigationFinal reportKory G. Cornum SH-3R · Auburn, ALThe failure of the pilot-in-command to maintain adequate airspeed after initiating a maneuver from low altitude. A factor was the lack of sufficient altitude.NTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.NTSB SEA92LA152Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH12D · Loman, IDFuel exhaustion. Factors include a short in the fuel quantity sensor/transmitter, an inadequate preflight, and a tree covered landing area.NTSB LAX92T#A11Accident · No injuriesClass 3Final reportMaule MX7-420 · Reno, NVNTSB LAX92LA297Accident · No injuriesLimited investigationFinal reportKrug Lincoln Sportplane · Corona, CAThe pilot/builder inadequate propeller component resulting in an inadequate climb performance. Contributing to this accident was the airplane's inability to climb.NTSB MIA92LA149Accident · No injuriesLimited investigationFinal reportMooney M20C · Pass-A-Grille, FLTotal loss of engine power due to fuel starvation.NTSB FTW92LA179Accident · No injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXThe pilot's failure to maintain directional control. Factors were the inadvertent porpoise of the airplane and the pilot's lack of total experience in the type airplane.NTSB DEN92LA073Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ft. Collins, COImproper rate of descent and lack of flare while conducting a forced landing. Factors were: partial power loss due to stuck exhaust valves caused by engine overheat from improper leaning.NTSB BFO92LA097Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bedford, PAThe pilot failed to maintain adequate airspeed which resulted in a stall.NTSB ANC92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot's inadvertent stalling of the airplane and an inadequate altitude in which he could recover. Factor relating to the accident was the water in the fuel.NTSB ANC92FA106Accident · 1 fatalField investigationFinal reportShort Brothers SC7 · Bethel, AKInadequate security of the cargo which shifted rearward during the takeoff roll. Factors which contributed to the accident were: the over gross weight condition, and the improper alteration of the tie down rings by the overhauling maintenance facility.NTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.NTSB LAX92LA322Accident · No injuriesLimited investigationFinal reportBeech A23A · Chico, CA1) The pilot's inadvertent entry into instrument meteorological conditions, 2) his failure to maintain control of the aircraft due to spatial disorientation, 3) the inadvertent entry into a spiral dive at an excessive airspeed, and, 4) the pilot's improper…NTSB CHI92LA205Accident · No injuriesLimited investigationFinal reportCessna 180H · Blaine, MNThe pilot's inadvertent activation of wheel brakes.NTSB BFO92LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beavertown, PAThe pilot's failure to maintain ground clearance. Contributing to the accident was a downdraft and insufficient altitude.NTSB BFO92LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA28-161 · Brentwood, NHA delay by the pilot in aborting the landing which resulted in failure to clear the obstacles.NTSB BFO92LA098Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bally, PAThe pilot failed to maintain directional control during takeoff.NTSB ANC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Watana Lodge, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the pilot's failure to attain the proper touch down point, and the loose object (large rock) on the landing strip.NTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.NTSB SEA92LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Delta, UTThe failure of an intake valve and the poorly executed forced landing.NTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.NTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.NTSB MIA92LA148Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sanford, FLInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid of the power line. The proximity of the power line was a related factor.NTSB LAX92LA296Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Soledad, CAThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.