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.

NTSB DCA95RA013Accident · No injuriesForeign investigationMcDonnell Douglas DC-9-14 · Maria La Baja, ColombiaJan 12, 1995 · HK383NTSB CHI95LA069Accident · No injuriesLimited investigationFinal reportCessna S550 · Newton, IAthe pilot-in-command's failure to attain runway alignment. A factor was a snowbank.Jan 12, 1995 · N287MC · Substantial damageNTSB 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.Jan 12, 1995 · N118UX · Minor damageNTSB 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.Jan 12, 1995 · N75PF · DestroyedNTSB 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.Jan 12, 1995 · N13SE · DestroyedNTSB 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.Jan 11, 1995 · N5464A · DestroyedNTSB 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.Jan 10, 1995 · N3708L · Substantial damageNTSB 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.Jan 10, 1995 · N321WN · Substantial damageNTSB 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.Jan 10, 1995 · N7340Q · Substantial damageNTSB FTW95FA087Accident · 3 fatalField investigationFinal reportBeech B95 · Hot Springs, ARThe pilot's failure to follow IFR and missed approach procedures.Jan 10, 1995 · N673Q · DestroyedNTSB 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.Jan 10, 1995 · N922VV · Substantial damageNTSB ATL95LA035Accident · No injuriesLimited investigationFinal reportCessna 310N · Covington, GAThe pilot's improper fuel management which resulted in fuel starvation and loss of engine power.Jan 10, 1995 · N4104Q · Substantial damageNTSB NYC95WA058Accident · No injuriesForeign investigationCessna 501 · Stuttgurt-Grmy, GermanyJan 9, 1995 · N555HR · Substantial damageNTSB 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…Jan 9, 1995 · N32TS · DestroyedNTSB 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.Jan 9, 1995 · N50WT · DestroyedNTSB 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.Jan 8, 1995 · N205MD · Substantial damageNTSB 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.Jan 8, 1995 · N29PG · DestroyedNTSB 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.Jan 8, 1995 · N9264D · Substantial damageNTSB 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.Jan 7, 1995 · N560WM · Substantial damageNTSB 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.Jan 6, 1995 · N981DL · No damageNTSB FTW95FA084Accident · 1 fatalField investigationFinal reportPiper PA-30 · Georgetown, TXLoss of power in both engines and loss of aircraft control for unknown reasons.Jan 6, 1995 · N8398Y · DestroyedNTSB 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…Jan 6, 1995 · N3LP · DestroyedNTSB ANC95LA026Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Dutch Harbor, AKThe partial failure of the right brake due to a leaky brake line.Jan 6, 1995 · N4492H · Substantial damageNTSB 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.Jan 5, 1995 · N25953 · Substantial damageNTSB FTW95WA081Accident · 2 fatalForeign investigationPiper Aerostar 601P · Toluca, MexicoJan 4, 1995 · N720EM · DestroyedNTSB 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.Jan 4, 1995 · N101GA · DestroyedNTSB 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.Jan 4, 1995 · CFGDZ · Substantial damageNTSB 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.Jan 4, 1995 · N8435P · DestroyedNTSB ATL95LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Fayetteville, TNThe pilot's improper use of carburetor heat.Jan 4, 1995 · N7185S · Substantial damageNTSB 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.Jan 4, 1995 · N73467 · Substantial damageNTSB 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.Jan 3, 1995 · N6172 · Substantial damageNTSB 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.Jan 3, 1995 · N94296 · DestroyedNTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.Jan 3, 1995 · N6829F · DestroyedNTSB 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.Jan 2, 1995 · N7098M · Substantial damageNTSB LAX95LA070Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Lancaster, CAfuel starvation due to the pilot's failure to select a tank containing fuel.Jan 2, 1995 · N200AW · Substantial damageNTSB 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.Jan 2, 1995 · N77FH · Substantial damageNTSB 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).Jan 2, 1995 · N242SS · Substantial damageNTSB 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.Jan 1, 1995 · N24457 · Substantial damageNTSB 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.Jan 1, 1995 · N5037 · Substantial damageNTSB 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.Jan 1, 1995 · N30898 · Substantial damageNTSB 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.Jan 1, 1995 · N3848X · Substantial damageNTSB 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.Jan 1, 1995 · N6106W · Substantial damageNTSB FTW95IA083Incident · No injuriesIncident investigationFinal reportBoeing 737-3A4 · Houston, TXEncounter with wake turbulence.Jan 1, 1995 · N326SW · No damageNTSB 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.Dec 31, 1994 · N4300S · Substantial damageNTSB 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.Dec 31, 1994 · N9WZ · DestroyedNTSB LAX95FA340Accident · 1 fatalField investigationFinal reportCessna 182B · Rancho Cucamong, CAthe failure of the pilot to maintain adequate altitude above mountainous terrain.Dec 31, 1994 · N2569G · DestroyedNTSB 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…Dec 31, 1994 · N26443 · DestroyedNTSB 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.Dec 31, 1994 · N92105 · Substantial damageNTSB 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.Dec 30, 1994 · N91090 · Substantial damageNTSB 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.Dec 30, 1994 · N30LC · Destroyed