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 LAX01LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sedona, AZthe induction manifold fire resulting from an engine backfire during engine start. The reason for the engine backfire was not determined.NTSB LAX01LA211Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Mountain View, CAThe pilot's failure to maintain control while hovering out of ground effect. A factor was the wind gusts.NTSB LAX01LA210Accident · No injuriesLimited investigationFinal reportCessna A185F · Ash Fork, AZThe pilot's misjudged touchdown location on a short runway. Contributing factors were the presence of a tailwind and the proximity of trees.NTSB LAX01FA212Accident · 1 fatalField investigationFinal reportSchultz Lancair IV-P · Flagstaff, AZthe builder's failure to install a fuel compartment vent in the right wing, affecting the total available fuel capacity, and resulting in the loss of engine power due to fuel starvation. A contributing factor was the pilot's intentional flight with a known…NTSB IAD01LA078Accident · 1 fatalLimited investigationFinal reportPatalivo Dominator · Laconia, NHThe non-certificated pilot's inability to maintain control of the gyrocopter after inadvertently allowing it to become airborne. A factor was the pilot's lack of flight experience.NTSB IAD01LA071Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Atwater, OHThe pilot's improper remedial response to a dynamic rollover event, which resulted in the helicopter rolling over on its side.NTSB IAD01LA067Accident · No injuriesLimited investigationFinal reportde Havilland DH-82 Tiger Moth · Allamuchy, NJThe loss of engine power over unsuitable terrain due to an exhaust valve stuck in the open position.NTSB CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.NTSB CHI01LA173Accident · No injuriesLimited investigationFinal reportCessna 172S · Cambridge, NEthe pilot's high airspeed and improper emergency procedures during the emergency landing. Factors relating to this accident were the fractured engine exhaust valve push rod, the bent intake valve push rod, and oil exhaustion during cruise flight, the…NTSB CHI01LA172Accident · Serious injuriesLimited investigationFinal reportShanklin RV-6A · Poseyville, INthe premature flare by the pilot.NTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…NTSB CHI01LA167Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Ottawa, ILthe failure of the passenger to maintain clearance from the windmilling propeller after exiting the airplane.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB CHI01FA180Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 · La Crosse, WIThe fatigue failure of the aircraft's left wing tip fuel tank rear attachment, while the aircraft was being maneuvered in a low approach, leading to the tank's in-flight separation and subsequent in-flight break up of the airplane and the aircraft's control…NTSB CHI01FA169Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Springfield, MOthe lack of experience in the type of airplane and directional control not maintained by the pilot. The improper flare and parked airplane were contributing factors.NTSB ANC01LA101Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Homer, AKThe student pilot's inadvertent ground loop. A factor in the accident was the pilot's lack of total experience.NTSB ANC01LA069Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's inadequate bounced landing recovery, and his failure to correct for torque/P-factor during an aborted landing.NTSB NYC01FA145Accident · 2 fatalField investigationFinal reportAeronca 7DC · Fulton, KYThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin to the ground. A factor was the pilot's decision to fly from the rear seat, which reduced his visibility of critical flight instruments, including the…NTSB MIA01FA163Accident · 1 fatalField investigationFinal reportCessna 172RG · Waveland, MSThe incapacitation of the pilot (cardiovascular) resulting in his inability to fly the airplane and subsequent in-flight collision with trees then a house.NTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.NTSB LAX01FA208Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Lanai City, HIthe CFI's inadequate in-flight planning/decision making, inadequate supervision, and his delayed remedial action, which resulted in controlled flight into terrain.NTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.NTSB FTW01LA144Accident · No injuriesLimited investigationFinal reportCessna 182A · Baytown, TXThe unqualified person's failure to maintain clearance with the power lines while maneuvering. A factor was the dark night light conditions.NTSB ENG01RA008Incident · No injuriesForeign investigationDornier 228-101 · Pokhara, NepalNTSB CHI01FA165Accident · Serious injuriesField investigationFinal reportVanderBeek Christen Eagle II · Plainfield, ILthe improper in-flight planning/decision and the aircraft control not maintained by the pilot. The thunderstorm outflow was a contributing factor.NTSB ANC01LA068Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Seward, AKThe pilot's inadequate compensation for crosswind conditions during taxi from landing. A factor in the accident was a crosswind.NTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB NYC01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150J · West Mifflin, PAThe pilot's failure to maintain airspeed while picking up a banner, and subsequent delay in releasing the banner, resulting in a stall/mush.NTSB NYC01LA144Accident · Minor injuriesLimited investigationFinal reportEurocopter France AS-350-BA · Hopewell, NJthe pilot's improper decision to continue flight in instrument meteorological conditions, and which resulted in an in-flight collision with trees. Factors were the fog, and dark night conditions.NTSB MIA01LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Venice, FLan on ground fire that started in the engine due to an excessive fuel flow causing the engine to flood. A factor in this accident was the pilot-in-command did not follow all the emergency procedures for an engine fire during start.NTSB MIA01LA168Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Key West, FLThe improper installation of the cylinders by other maintenance personnel for failure to assure that the cylinders were properly torqued resulting in fatigue crack in the crankshaft, and crankshaft failure. A finding in the investigation was fretting of both…NTSB MIA01FA162Accident · 1 fatalField investigationFinal reportBeech C90 · Fort Lauderdale, FLthe pilot's failure to properly plan fuel consumption and to perform an en route refueling, resulting in a total loss of engine power due to fuel exhaustion while on downwind leg for landing at eventual destination, causing an emergency descent and collision…NTSB LAX01FA207Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Stockton, CAa loss of engine power for undetermined reasons. Also causal was the inadequate supervision of the flight by the CFI for allowing a simulated emergency maneuver to continue below an altitude which would not allow for recovery contingencies.NTSB FTW01LA143Accident · Minor injuriesLimited investigationFinal reportCommander 114-B · Okmulgee, OKthe failure of the #6 cylinder's connecting rod, which resulted in a complete loss of engine power. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB FTW01LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, TXA loss of engine power for undetermined reasons. Contributing to the accident was the collapse of the landing gear for undetermined reasons.NTSB CHI01LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Green Bay, WIThe pilot not performing the pre-landing checklist, and the wheels-up landing made by the pilot.NTSB CHI01LA174Accident · No injuriesLimited investigationFinal reportSmith Aerostar 600 · Wonewoc, WIThe deer on the runway as the airplane was landing.NTSB SEA01LA178Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Glide, ORInadequate compensation for wind conditions during takeoff resulting in the pilot's failure to maintain directional control. Wind gusts, down sloping terrain and a fence post were factors.NTSB DEN01LA116Accident · Serious injuriesLimited investigationFinal reportCameron Balloons N-210 · Rio Rancho, NMthe pilot's inadvertent weather encounter with wind shear, and the resulting inability to maintain the proper landing descent rate, which resulted in a hard landing. A factor was the high wind weather condition.NTSB MIA01LA161Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennettsville, SCThe pilot's improper correction for wind conditions and his failure to maintain control of the airplane resulting in the airplane sliding off an embankment during taxi from landing.NTSB MIA01LA160Accident · No injuriesLimited investigationFinal reportCessna 182S · Corolla, NCThe pilots failure to maintain directional control during landing flare and touchdown resulting in the airplane touching down on the left side of the runway and the left wing contacting trees.NTSB FTW01LA145Accident · No injuriesLimited investigationFinal reportCessna 172S · Baton Rouge, LAthe student pilot's improper recovery from a bounced landing.NTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.NTSB CHI01MA163Accident · Serious injuriesMajor investigationFinal reportLearjet 25D · Salina, KSThe PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…NTSB CHI01LA162Accident · No injuriesLimited investigationFinal reportGiackino Exec 162F · Manistique, MIThe contamination of the main rotor drive belts causing them to slip. Factors were the low altitude, unsuitable terrain for the forced landing, and the water.NTSB SEA01LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Canby, ORFuel starvation as a result of a collapsed fuel nozzle filter screen. Contamination that blocked the fuel nozzle screen and water contamination were factors.NTSB SEA01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Billings, MTThe pilot-in-command's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the gusty crosswind conditions.NTSB NYC01LA142Accident · Minor injuriesLimited investigationFinal reportCessna 170A · South Charlesto, WVThe pilot's failure to maintain directional control while landing.NTSB NYC01FA141Accident · 3 fatalField investigationFinal reportCessna P210N · Honesdale, PAAn improperly manufactured torquemeter gearshaft assembly, which resulted in gearshaft assembly failure, an N2 overspeed, and a subsequent uncontained engine failure.NTSB MIA01LA159Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dahlonega, GAThe failure of the No. 3 exhaust valve due to fatigue cracking for undetermined reasons, which resulted in a partial loss of engine power and an in-flight collision with a building during an attempted forced landing to unsuitable terrain..