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 LAX91LA301Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Eloy, AZThe failure of the pilot to maintain the terrain clearance of the aircraft while maneuvering for a potential emergency landing on a moonless dark night.NTSB LAX91LA299Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crows Landing, CAThe pilot Landing his airplane erroneously on the wrong Landing surface. Factors in this accident were: sunglare and its interference with the pilot's vision and the soft terrain.NTSB LAX91LA298Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Indian Springs, NVFuel exhaustion due to improper preflight planning, and failure to refuel the aircraft. Factors in the accident were: 1) the pilot becoming lost/disoriented ; 2) the dark night conditions; 3) the failure of the pilot to seek help in a timely fashion; and 4)…NTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.NTSB DEN91FA098Accident · No injuriesField investigationFinal reportBoeing 707-323C · Denver, COImproper overhaul of the nose gear assembly by other maintenance personnel.NTSB BFO91LA067Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Norton, WVThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the lost of engine power.NTSB ANC91LA093Accident · Minor injuriesLimited investigationFinal reportHelio H-295 · Port Alsworth, AKFailure of the pilot to maintain sufficient altitude and clearance from mountainous terrain. Factors related to the accident were: the rising terrain and a downdraft.NTSB SEA91LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Dayton, WYSevere down drafts. Factors to the accident were: terrain clearance was not maintained, and a poor weather evaluation, by the pilot.NTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…NTSB LAX91LA300Accident · No injuriesLimited investigationFinal reportCessna 320 · Reno, NVThe fatigue failure of the propeller feathering counter weight clamp assembly.NTSB LAX91LA296Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Minden, NVThe flight instructor's inadequate supervision of the student pilot during a simulated emergency.NTSB BFO91LA066Accident · No injuriesLimited investigationFinal reportCessna 175B · Farmington, MDAn aborted takeoff due to the pilot's reported binding of the elevator.NTSB ATL91LA126Accident · Serious injuriesLimited investigationFinal reportMoeckel Bakeng Duce · Dawson, GAThe pilot's abrupt rotation after failing to maintain directional control during takeoff roll, and his failure to maintain airspeed during the initial climb, which resulted in a stall. A factor in the accident was: the pilot's lack of familiarity with the…NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB SEA91LA162Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · West Jordan, UTThe pilot's delayed switching of the fuel tank selector, the engine failure from fuel starvation and the unsuitable terrain for a forced landing.NTSB SEA91LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Sequim, WAThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was a hidden obstruction.NTSB SEA91LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bryce Canyon, UTThe pilot's entry into a stall/mush condition shortly after take off. Contributing to the accident was the high density altitude.NTSB SEA91FA157Accident · 3 fatalField investigationFinal reportBeech V35B · Roche Harbor, WAThe pilot's failure to plan his takeoff path to provide adequate terrain clearance. The rising terrain and dark night light conditions were contributing factors.NTSB NYC91LA175Accident · No injuriesLimited investigationFinal reportCessna 182 · Xenia, OHTotal loss of engine power due to fuel exhaustion resulting in a forced landing and subsequent nose over during the landing roll. Factors related to the accident was the pilot's failure to ensure sufficient fuel was available for the flight.NTSB LAX91LA294Accident · No injuriesLimited investigationFinal reportCessna 140 · Montague, CAThe failure of an exhaust valve in the engine.NTSB LAX91LA293Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Shoshone, CAAn electrical short of the battery cable.NTSB FTW91LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Sonora, TXThe pilot's improper aircraft control during the takeoff ground run. Factors were the density altitude and the rough terrain.NTSB DEN91FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Denver, COImproper planning/decision by the pilot. Factors related to the accident were: a tail wind, the high density altitude, the pilot's failure to properly lean the mixture, and his failure to use all available runway.NTSB CHI91LA213Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stockton, IACompensation for wind conditions not performed, wrong runway selected and aircraft control not maintained by the pilot. Factors related to the accident were a tailwind/crosswind component and a rough runway.NTSB CHI91FA212Accident · Serious injuriesField investigationFinal reportCentrair Pegasus 101B · Hinckley, ILThe failure of both pilots to maintain adequate visual lookout and ensure adequate separation during traffic pattern operations. A related factor is the non-standard uncontrolled airport procedures used by N126CC.NTSB CHI91FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Quincy, ILThe failure by the pilot of the other airplane to maintain clearance. Factors in the accident were the pilot's attempt to fly formation, his inadequate group briefing, and the lack of experience on the part of the pilot of the other airplane.NTSB ANC91LA095Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairbanks, AKThe partial loss of engine power resulting in a forced landing on unsuitable terrain and subsequent nose over during the landing roll. Contributing to the accident was the improperly performed 100 hour inspection by company maintenance personnel.NTSB SEA91LA158Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Benton City, WAThe pilot's disregard of the airplane's performance capability. Contributing to the accident was high density altitude.NTSB SEA91FA156Accident · 2 fatalField investigationFinal reportChampion 7AC · Burns, ORImproper inflight planning/decision by the student pilot (pilot-in-command), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: physical impairment of the student pilot/owner/operator from carbon…NTSB MIA91LA182Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S2A · Eustis, FLThe loss of elevator control in flight due to a screwdriver jamming the elevator control for unknown causes.NTSB MIA91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Everglades City, FLUnsuitable terrain encountered during a precautionary landing.NTSB MIA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valparaiso, FLPartial loss of engine power due to fuel contamination due to an inadequate preflight by the pilot in command and failure of the pilot to extend the landing gear during the forced landing.NTSB LAX91LA295Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Duncan, AZThe pilot's failure to maintain a proper airspeed during the approach and an inadvertent entry into a stall/mush which resulted in a hard landing.NTSB LAX91LA291Accident · No injuriesLimited investigationFinal reportBeech F33A · Wickenberg, AZThe loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB LAX91LA290Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Trinity Center, CAThe pilot's failure to ensure an adequate supply of fuel was available. Contributing to this accident was soft terrain.NTSB LAX91FA292Accident · 2 fatalField investigationFinal reportBeech G35 · Pacoima, CAImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation.NTSB BFO91LA065Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Clarksville, MDThe pilot's improper flare and failure to arrest his descent rate.NTSB ANC91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eureka, AKThe pilot-in-command's failure to maintain airspeed and directional control of the airplane during the initial climb.NTSB ANC91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodchopper Crk, AKEngine failure due to fuel exhaustion, the pilot's inadequate preflight planning and the unsuitable terrain. Contributing to the accident was the pilot's lack of total experience.NTSB ANC91LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Merrill Pass, AKThat the pilot failed to maintain an airspeed above stall speed. Contributing to the accident was the turbulence.NTSB ANC91FA090Accident · Minor injuriesField investigationFinal reportCessna 185A · Valdez, AKLoss of aircraft control for an undetermined reason during an approach to land.NTSB SEA91IA159Incident · No injuriesIncident investigationFinal reportGalaxy GLX-7 · Provo, UTThe pilot's diverted attention. Facotrs include on ground contact with a fence.NTSB NYC91LA172Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, OHAn inflight collision with terrain after the pilot became incapacitated due to an allergic reaction to bee stings. A factor related to the accident was the failure of the pilot to recognize the situation in time to make the recovery.NTSB NYC91LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Millville, OHThe pilot's improper in-flight planning/decision after becoming lost, resulting in engine fuel exhaustion. Factors related to the accident were: the pilot's lack of familiarity with the geographic area, and his lack of experience in this type of operation.NTSB NYC91FA171Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Wernersville, PAThe pilot's loss of airplane control due to spatial disorientation/vertigo. Factors related to the accident were the pilot's use of an antihistamine and self induced pressure to complete the flight.NTSB MIA91LA179Accident · No injuriesLimited investigationFinal reportCessna 182C · Keystone Hghts, FLTotal loss of engine power due to fuel exhaustion due to fuel siphoning overboard, and failure of the pilot to perform an adequate preflight inspection to insure the fuel caps were secured. Contributing to the accident was incorrect fuel tank quantity gauges…NTSB MIA91LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Rontonda West, FLThe failure of the pilot-in-command to maintain an adequate visual lookout which caused him to fly the airplane into wires.NTSB LAX91LA289Accident · No injuriesLimited investigationFinal reportHughes 369D · Napa, CAThe pilot's failure to maintain the proper altitude. Contributing to the accident was the pilot's improper in flight decision to fly in the below VFR weather conditions and his misjudged weather evaluation.NTSB LAX91FA288Accident · 1 fatalField investigationFinal reportRobinson R-22B · Phoenix, AZA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the cockpit.NTSB FTW91LA117Accident · Minor injuriesLimited investigationFinal reportThorp T-18CW · Wimberley, TXThe failure of the airport personnel to maintain the airstrip in an operable condition and the pilots failure to maintain runway alignment on touchdown.