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 DCA95RA013Accident · No injuriesForeign investigationMcDonnell Douglas DC-9-14 · Maria La Baja, ColombiaNTSB CHI95LA069Accident · No injuriesLimited investigationFinal reportCessna S550 · Newton, IAthe pilot-in-command's failure to attain runway alignment. A factor was a snowbank.NTSB CHI95IA066Incident · No injuriesIncident investigationFinal reportBeech 1900D · Williston, NDthe improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.NTSB ATL95FA044Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Spring City, TNThe pilot's inadequate preflight planning, and his continued VFR flight into instrument weather conditions which resulted in the collision with the mountain. A factor was low ceilings.NTSB ATL95FA036Accident · 4 fatalField investigationFinal reportCessna 414 · Augusta, GAThe loss of power on the left engine for undetermined reasons. A factor was the failure of the right engine due to maintenance personnel's failure to properly torque the cylinder through bolts.NTSB ATL95LA037Accident · Serious injuriesLimited investigationFinal reportCessna P210R · Lumberton, NCThe failure of the pilot to maintain aircraft control during the approach for landing, resulting in a collision with objects.NTSB SEA95LA036Accident · No injuriesLimited investigationFinal reportCessna 172G · Salt Lake City, UTThe pilot's inadequate compensation for wind conditions during runup. The unfavorable wind was a factor.NTSB LAX95LA075Accident · No injuriesLimited investigationFinal reportKaman HH43 · Glendale, AZThe pilot's failure to maintain an adequate visual lookout to avoid a collision with a tree during an aerial application swath run.NTSB FTW95LA086Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lufkin, TXThe pilot's impairment of judgment and performance due to multiple drugs, which resulted in his failure to maintain control of the airplane during the approach/flare for landing.NTSB FTW95FA087Accident · 3 fatalField investigationFinal reportBeech B95 · Hot Springs, ARThe pilot's failure to follow IFR and missed approach procedures.NTSB ATL95LA038Accident · No injuriesLimited investigationFinal reportDouglas DC-9-32 · Memphis, TNThe ground personnel's improper handling of the aircraft while in tow, and the operator's failure to provide sufficient requirements for this situation.NTSB ATL95LA035Accident · No injuriesLimited investigationFinal reportCessna 310N · Covington, GAThe pilot's improper fuel management which resulted in fuel starvation and loss of engine power.NTSB NYC95WA058Accident · No injuriesForeign investigationCessna 501 · Stuttgurt-Grmy, GermanyNTSB NYC95FA049Accident · 1 fatalField investigationFinal reportBeech G35 · West Palm Beach, FLImproper top overhaul by maintenance personnel, and improperly torqued crackcase thru-bolts and cylinder deck studs at the number one cylinder, which led to fatigue failure of four of the bolts, failure and/or separation of the number one cylinder, and a…NTSB FTW95LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Brownsville, TXThe fuel starvation loss of engine power due to the pilot's improper use of the fuel tank selector. Factors were the pilot's qualification and the lack of suitable terrain for landing.NTSB MIA95LA056Accident · Minor injuriesLimited investigationFinal reportMooney 20J · St. Petersburg, FLThe failure of the No. 3 connecting rod bolt due to oil starvation for undetermined reasons. This resulted in a total loss of engine power, forced landing, and subsequent ditching.NTSB CHI95DTK01Accident · 1 fatalFinal reportGay RV-4 · Lennox, SDThe pilot's failure to maintain adequate altitude while performing aerobatic maneuvers. The pilot's impairment of judgment and performance due to drugs was a factor.NTSB ANC95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKA failure of the pilot to perform an adequate pre-flight inspection of the airplane. Factors in the accident were a frozen gascolator, and restricted fuel supply.NTSB NYC95LA048Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Canfield, OHThe pilot's decision to abort the takeoff on a snow and ice covered runway, and once made, the pilot's decision to lower the flaps.NTSB MIA95LA055Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Monroe, LAan in-flight encounter with weather during a climb, resulting in an injury to a flight attendant who got out of her seat to perform a duty.NTSB FTW95FA084Accident · 1 fatalField investigationFinal reportPiper PA-30 · Georgetown, TXLoss of power in both engines and loss of aircraft control for unknown reasons.NTSB FTW95FA082Accident · 3 fatalField investigationFinal reportBeech A60 · Hurley, NMThe pilot's failure to maintain airspeed during a single engine approach resulting in an inadvertent stall. Factors were a fatigue separation of a shaft in the left engine turbocharger due to use of a Federal Aviation Administration approved overhaul…NTSB ANC95LA026Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Dutch Harbor, AKThe partial failure of the right brake due to a leaky brake line.NTSB LAX95LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe improper supervision of the student pilot by the instructor by allowing the student to inadvertently pull the mixture control handle too far out causing the engine to lose power. The wet terrain condition was a factor.NTSB FTW95WA081Accident · 2 fatalForeign investigationPiper Aerostar 601P · Toluca, MexicoNTSB FTW95FA080Accident · 2 fatalField investigationFinal reportBeech 65-90 · Royal, ARThe pilot inadvertently allowed the airplane to descend and collide with trees, after he became diverted by an inoperative cabin heater. Darkness was a related factor.NTSB CHI95LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Int'L Falls, MNengine oil exhaustion due to a frozen crankcase breather line and noncompliance with an airworthiness directive.NTSB BFO95FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Miamisburg, OHThe pilot's failure to switch fuel tanks which led to fuel starvation and subsequent loss of engine power.NTSB ATL95LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Fayetteville, TNThe pilot's improper use of carburetor heat.NTSB ANC95LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiak, AKA failure of the pilot to maintain directional control of the airplane. Icy runway conditions and a lack of a local NOTAM to report the runway condition by local maintenance personnel were factors in the accident.NTSB MIA95LA054Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot's failure to maintain altitude while descending over a lake, resulting in an in-flight collision with water.NTSB LAX95FA072Accident · 1 fatalField investigationFinal reportCessna A185F · Tehachapi, CAThe noninstrument-rated pilot's continued flight into known adverse weather, and his failure to maintain adequate airspeed while maneuvering to reverse direction. Factors relating to the accident were: the mountainous terrain, and adverse weather conditions.NTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.NTSB LAX95LA071Accident · No injuriesLimited investigationFinal reportCessna 175 · Davis, CAthe failure of the pilot to maintain directional control of the aircraft while on the rollout phase of landing on a dirt road. A factor in the accident was the pilot's intentional selection of the road as a landing site.NTSB LAX95LA070Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Lancaster, CAfuel starvation due to the pilot's failure to select a tank containing fuel.NTSB ATL95LA032Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Union City, TNThe improper preflight planning by the pilot which resulted in the exhaustion of the aircraft's fuel. The rough terrain condition was a factor.NTSB ANC95LA023Accident · No injuriesLimited investigationFinal reportCessna 208 · Craig, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the sun glare, the partially submerged log, and the shallow fog layer on the surface of the water (landing surface).NTSB MIA95LA052Accident · Minor injuriesLimited investigationFinal reportCessna 152 · New Smyrna Bch., FLIntentional flight into known instrument meteorological conditions by a noninstrument-rated pilot, and the pilot's subsequent spatial disorientation. Contributing to the accident was the pilots' overconfidence in his personal ability.NTSB MIA95FA053Accident · 2 fatalField investigationFinal reportLarson, C.H. Cozy MK IV · Wauchula, FLDistance vs. altitude misjudged by the pilot-in-command while on short final approach. Additionally, altitude/clearance not maintained while on short final approach resulting in the collision with an unmarked static power line.NTSB FTW95LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Torreon, NMThe pilot's failure to attain proper liftoff speed resulting in an inadvertent stall and the failure to remove frost from the wing. A factor was fatigue.NTSB FTW95LA078Accident · No injuriesLimited investigationFinal reportCessna 310Q · Guthrie, OKThe pilot's flight into known adverse weather resulting in an inadvertent stall. A factor was icing conditions.NTSB FTW95LA077Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Albuquerque, NMThe pilot did not align the aircraft with the runway. Factors were the dusk light conditions and the pilot's failure to activate the pilot controlled runway lights.NTSB FTW95IA083Incident · No injuriesIncident investigationFinal reportBoeing 737-3A4 · Houston, TXEncounter with wake turbulence.NTSB MIA95LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeland, FLFatigue failure of the engine no.1 valve spring that jammed the intake valve open resulting in partial loss of engine power.NTSB LAX95LA067Accident · 1 fatalLimited investigationFinal reportHarris BD-10 · Gardnerville, NVthe in-flight overload failure of the left vertical stabilizer spars, at force levels substantially below the predicted ultimate failure loads, due to inadequate substantiation by the designer.NTSB LAX95FA340Accident · 1 fatalField investigationFinal reportCessna 182B · Rancho Cucamong, CAthe failure of the pilot to maintain adequate altitude above mountainous terrain.NTSB LAX95FA068Accident · 2 fatalField investigationFinal reportGrumman AA-5A · San Luis Obispo, CAthe pilot's intentional flight into an area of known marginal weather conditions during a night cross-country flight and the flight's subsequent inadvertent entry into instrument meteorological conditions at an altitude insufficient to remain clear of the…NTSB ANC95LA031Accident · No injuriesLimited investigationFinal reportCessna 182M · New Stuyahok, AKA failure of the pilot to maintain directional control of the airplane during the landing roll. A factor in the accident was an icy runway surface.NTSB LAX95LA066Accident · No injuriesLimited investigationFinal reportCessna 207 · Fort Huachuca, AZThe failure of the radar and tower controllers to ensure that the pilot was aware of the runway status. Factors related to the accident were the downwind no-flap landing and the sunglare.NTSB ATL95FA031Accident · 2 fatalField investigationFinal reportCessna 310Q · St. Augustine, FLThe non-instrument rated pilot's attempted flight into known instrument meteorological conditions which resulted in spatial disorientation and loss of control.