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 DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB CHI00LA220Accident · Serious injuriesLimited investigationFinal reportFloroski Anderson Kingfisher · Deerwood, MNthe open carburetor heat air box resulting in a loss of engine power, the diminished climb rate and the altitude/clearance not possible by the pilot. Factors were the trees and the bent carburetor heat push-pull rod.NTSB CHI00LA217Accident · No injuriesLimited investigationFinal reportCessna 182S · Millard, NEthe improper recovery from the bounced landing and the porpoise encountered by the pilot. Factors were the misjudged flare by the pilot and the runway light.NTSB CHI00LA215Accident · No injuriesLimited investigationFinal reportLutke Rotoway Exec 90 · Kalamazoo, MIthe loss of main rotor rpm due to the failure of the top engine mount and the subsequent loss of the main rotor drive belt tension. A factor was the confined area landing zone.NTSB CHI00FA214Accident · 1 fatalField investigationFinal reportPiper PA-23 · Dodge Center, MNThe pilot not maintaining airplane control in his turn back in the direction of the airport and the pilot not performing an emergency landing straight ahead. Factors were the water and debris contamination found in the fuel screens and carburetor bowl and the…NTSB SEA00TA138Accident · No injuriesFinal reportCessna 182R · John Day, ORThe pilot's improper flare on touchdown resulting in a hard landing. A factor was the pilot's entrance into an inadvertent porpoise condition.NTSB SEA00LA141Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Grand View, IDInternal deterioration of a fuel line, resulting in loss of engine power. Factors included obstruction of the fuel line, fuel starvation, and a fence in the forced landing area.NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.NTSB SEA00LA137Accident · No injuriesLimited investigationFinal reportBeaver Ferguson F-II · Benton City, WAThe pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…NTSB LAX00MA273Accident · 7 fatalMajor investigationFinal reportAerospatiale AS 355F1 · Kahului, Maui, HIThe pilot's inadequate decision by which he continued visual flight rules flight into instrument meteorological conditions. Also causal was his failure to maintain terrain clearance resulting in a collision with mountainous terrain. A contributing factor was…NTSB LAX00LA275Accident · Minor injuriesLimited investigationFinal reportSteel/Vans RV6 · Winnemucca, NVA loss of power due to overheating resulting from the failure of the engine build-up facility to install a vernatherm.NTSB CHI00LA213Accident · No injuriesLimited investigationFinal reportCessna 120 · Shawano, WIInadequate preflight planning and the pilot's delay in aborting the takeoff. A factor was the road embankment.NTSB ANC00FA093Accident · 1 fatalField investigationFinal reportCessna 180 · Thorne Bay, AKThe pilot-in-command's inadvertent stalling of the airplane.NTSB NYC00LA204Accident · No injuriesLimited investigationFinal reportBoeing PT17 · Easton, MDThe pilot's failure to maintain aircraft control.NTSB MIA00RA224Accident · 2 fatalForeign investigationDouglas DC-3 · Nassau, BahamasNTSB MIA00LA226Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilots failure to calculate his takeoff distance for the conditions, resulting in an in-flight collision with a fence, trees, and the terrain. A factor in the accident is the FAA's failure to require of the manufacturer and the manufacturer's failure to…NTSB FTW00LA215Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Lubbock, TXThe pilot's improper aircraft handling as a result of his alcohol impairment.NTSB ANC00LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Anchorage, AKThe failure of the pilot-in-command (CFI) to adequately supervise the instructional flight. Factors in the accident were an inadvertent spin entry by the student, and the pilot-in-command's failure to utilize adequate altitude for a stall demonstration.NTSB NYC00MA201Accident · 2 fatalMajor investigationFinal reportGrumman G-159 · Linneus, METhe pilot-in-command's failure to maintain minimum control airspeed, which resulted in a loss of control. Factors in this accident were clouds, and a loss of engine power for undetermined reasons, while in cruise flight above the airplane's single engine…NTSB NYC00LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Columbus, OHa partial power loss for undetermined reason(s).NTSB LAX00LA276Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Cave Creek, AZThe pilot's inadequate in-flight planning/decision to attempt a hover in atmospheric conditions and over terrain that would require maximum helicopter performance, and which would leave no viable alternate actions in the event of difficulties.NTSB LAX00IA272Incident · No injuriesIncident investigationFinal reportCanadair CL-65 · Monterey, CAFatigue failure of the bell gear in the horizontal stabilizer trim actuator system.NTSB FTW00LA214Accident · 1 fatalLimited investigationFinal reportBurton/Boyton Celerity · Horseshoe Bend, ARThe loss of control while maneuvering for an undetermined reason.NTSB DEN00LA134Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Pagosa Springs, COThe pilot inadvertently stalling the airplane. Factors were the pilot's failure to use the entire available runway, the high density altitude weather condition, and a partial loss of power on one engine due to a burned exhaust valve.NTSB SEA00LA136Accident · 1 fatalLimited investigationFinal reportErcoupe 415-D · Hamilton, MTThe excessive rate at which the student pilot allowed the aircraft to descend into the runway surface while attempting to land. Factors include the pilot's lack of experience in airplanes.NTSB MIA00LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Jesup, GAThe failure of the student pilot to maintain directional control during takeoff resulting in an excursion off the runway and collision with adjacent foliage. A factor in the accident was the student's decision to takeoff downwind.NTSB LAX00LA270Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Luis Obispo, CAThe pilot's inadequate visual lookout while taxiing to the runway, which resulted in his failure to see and avoid the fuel truck.NTSB IAD00RA064Accident · 1 fatalForeign investigationHughes 369D · Nuuk, GreenlandNTSB IAD00LA063Accident · No injuriesLimited investigationFinal reportBeech BE-55 (T42A) · Chesapeake, VAthe pilot's misjudgment of his altitude/clearance above the runway during the aborted takeoff which resulted in an improper flare for landing. A factor in the accident was the pilot's premature rotation during the takeoff roll.NTSB IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.NTSB FTW00LA212Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401 · Panhandle, TXThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB DEN00FA136Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Moab, UTThe pilot in command exercising poor judgment and exceeding the aircraft's turning capability. Contributing factors were the pilots' attention being diverted, flying into a known blind canyon, high temperature, and high density altitude.NTSB CHI00LA212Accident · 1 fatalLimited investigationFinal reportHess RH-1 Falcon · New Castle, INaircraft control not attained by the pilot.NTSB CHI00LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Warrensburg, MOinadequate airspeed on takeoff that resulted in a stall/mush condition. Factors associated with the accident were the wet, grass runway, and the trees near the departure end of the runway.NTSB CHI00LA205Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Decatur, MIthe left main landing gear brake was locked during landing. A factor associated with the accident was the uneven terrain on which the landing was made.NTSB NYC00LA200Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Richfield Sprng, NYFailure of the number two cylinder main bearing for undetermined reasons.NTSB MIA00LA222Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Covington, TNthe pilot allowed the helicopter to get too low while hovering, which resulted in the tail rotor striking the ground, the separation of the blade, and subsequent force landing.NTSB MIA00FA221Accident · 1 fatalField investigationFinal reportBeech 58 · Hernando, MSThe arcing of an electrical wire behind the instrument panel and the associated cracking of fuel and oil lines. Also causal was the pilot's inappropriate remedial action not in accordance with the emergency checklist.NTSB DEN00LA132Accident · Minor injuriesLimited investigationFinal reportSpencer Long EZE · Farmington, NMFailure of the coolant recovery system, resulting in overheating of the engine. A factor was the soft ground on which the forced landing was made.NTSB DCA00WA076Accident · 60 fatalForeign investigationBoeing 737-200 · Patna, IndiaNTSB CHI00LA206Accident · 1 fatalLimited investigationFinal reportMead Kolb Firestar II · Gwinn, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the tree and the high density altitude.NTSB ANC00LA091Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Big Lake, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.NTSB NYC00LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norwood, MAthe pilot's improper bounced landing recovery. A factor was the pilot's lack of total flight experience.NTSB NYC00LA202Accident · No injuriesLimited investigationFinal reportCessna 172H · Rainelle, WVThe pilot's failure to maintain a proper decent rate. A factor was the up-sloping runway.NTSB NYC00LA199Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Lawrence, MAThe pilot's failure to attain the proper touchdown point and his delayed remedial action. Also causal was the pilot's lack of recent experience. A factor in the accident was the tailwind condition.NTSB NYC00LA198Accident · Serious injuriesLimited investigationFinal reportWarrington Surrel Guppy · Churchville, MDThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were an open canopy and a decrease in engine power.NTSB MIA00LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Washington, NCThe inadvertent stall by the pilot-in-command while returning for a precautionary landing. Contributing to the accident was the loose engine cowling.NTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…NTSB LAX00LA268Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Payson, AZThe pilot's selection of an unsuitable takeoff area. Contributing factors were the high density altitude and proximity to vegetation.NTSB FTW00LA206Accident · No injuriesLimited investigationFinal reportMbb BK-117-A3 · Allen, TXthe pilot's failure to maintain obstacle clearance while hovering the helicopter. A contributing factor was the dark night light conditions.