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 LAX95LA211Accident · 1 fatalLimited investigationFinal reportHarmon Dolphin · Paso Robles, CAThe pilot's decision continue VFR flight into instrument meteorological conditions (IMC), loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the airplane. The weather condition was a related factor.Jun 17, 1995 · N89JH · DestroyedNTSB LAX95FA210Accident · 1 fatalField investigationFinal reportCessna P210N · Mammoth Lakes, CAthe pilot's continued flight into instrument meteorological conditions during dark nighttime over mountainous terrain; and his failure to maintain an adequate altitude to ensure terrain clearance. Thw weather and terrain were factors.Jun 17, 1995 · N333HF · DestroyedNTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.Jun 17, 1995 · N4562 · Substantial damageNTSB FTW95LA249Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Fort Stockton, TXThe fuel exhaustion induced power loss due to the pilot becoming lost/disoriented. The lack of suitable terrain for the forced landing and the weather conditions were factors.Jun 17, 1995 · XBGPJ · Substantial damageNTSB CHI95LA192Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Peru, ILthe pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.Jun 17, 1995 · N21873 · Substantial damageNTSB CHI95LA185Accident · Serious injuriesLimited investigationFinal reportChristen Industries S-2B · Elgin, ILthe pilot's incapacitation due to alcohol and drugs which led to a loss of consciousness.Jun 17, 1995 · N260RG · DestroyedNTSB CHI95LA184Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Neligh, NEthe pilot's selection of the wrong runway for takeoff, and his failure to compensate for the tailwind. A factor was the tailwind.Jun 17, 1995 · N7632R · Substantial damageNTSB ATL95LA112Accident · Minor injuriesLimited investigationFinal reportGrumman AA1C · Mocksville, NCThe pilot's improper short field takeoff procedure which resulted in the inadvertent stall/mush during the takeoff.Jun 17, 1995 · N9980U · Substantial damageNTSB SEA95LA122Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WAThe pilot's inadequate remedial action when he encountered porpoising after landing on the nosewheel.Jun 16, 1995 · N19806 · Substantial damageNTSB FTW95LA248Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18 · Cherry Valley, ARFuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for a forced landing.Jun 16, 1995 · N2177Q · Substantial damageNTSB FTW95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Guymon, OKThe pilot's failure to maintain airspeed. The high density altitude was a factor.Jun 16, 1995 · N315PF · DestroyedNTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.Jun 15, 1995 · N6669Q · DestroyedNTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jun 15, 1995 · N7070U · Substantial damageNTSB BFO95FA064Accident · 3 fatalField investigationFinal reportPiper PA-31P-350 · Cedar Bluff, VAthe pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.Jun 15, 1995 · N922DC · DestroyedNTSB ATL95LA111Accident · No injuriesLimited investigationFinal reportCessna 188D · Athens, ALThe pilot's inadequate lookout, and his failure to maintain clearance from the utility line.Jun 15, 1995 · N8035V · DestroyedNTSB ATL95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Huntsville, ALThe downdraft weather condition, and the pilot's failure to maintain adequate clearance from the terrain during his maneuver.Jun 15, 1995 · N5621G · DestroyedNTSB ANC95LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Gulkana, AKThe pilot's failure to maintain directional control during the landing roll.Jun 15, 1995 · N4512C · Substantial damageNTSB SEA95LA118Accident · No injuriesLimited investigationFinal reportEnstrom 280C · The Dalles, ORA partial loss of engine power due to one set of ignition points becoming loose during flight. Factors included the low altitude flight and maneuvering required to conduct the operation and the resulting lack of suitable terrain for a forced landing.Jun 14, 1995 · N51657 · Substantial damageNTSB FTW95LA244Accident · 1 fatalLimited investigationFinal reportWalter W. Bell Lazer Edge · El Reno, OKThe pilot's failure to maintain control resulting in an inadvertent stall/spin. Factors were the pilot's performance of aerobatic maneuvers at the low altitude.Jun 14, 1995 · N33PE · DestroyedNTSB FTW95LA240Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Iowa, LAThe failure of the right brake due to the hydraulic fluid leaking. Factors were proper alignment not possible and the close proximity of the ditch.Jun 14, 1995 · N627LL · Substantial damageNTSB CHI95LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lowell, MIthe pilot's failure to obtain/maintain altitude/clearance.Jun 14, 1995 · N3625R · Substantial damageNTSB CHI95FA182Accident · 2 fatalField investigationFinal reportGrumman G-21E · West Chicago, ILThe pilot allowed excessive nose-up rotation of the airplane during lift-off, and failed to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's…Jun 14, 1995 · N121H · DestroyedNTSB ATL95LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Brownsville, TNThe pilot's improper in-flight decision to land on the wet, sod runway, and his failure to use all of the available runway for landing.Jun 14, 1995 · N54484 · Substantial damageNTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.Jun 13, 1995 · N1299R · Substantial damageNTSB FTW95LA241Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Denver City, TXThe loss of engine power due to a fracture of the #3 cylinder resulting in the total failure of the cylinder. A factor was the lack of suitable terrain for the forced landing.Jun 13, 1995 · N15111 · DestroyedNTSB CHI95LA179Accident · No injuriesLimited investigationFinal reportCessna T210M · Downers Grove, ILthe pilot's failure to attain the proper touchdown point, and his subsequent failure to execute a go-around.Jun 13, 1995 · N112YM · Substantial damageNTSB CHI95LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bay City, MIFailure of the pilot to maintain clearance from obstacles and his intentional buzzing.Jun 13, 1995 · N5256T · Substantial damageNTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.Jun 13, 1995 · N4916Q · Substantial damageNTSB ATL95LA108Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Garfield, GAThe pilot's failure to maintain flying speed during a climbout from a swath run which resulted in a stall and the subsequent collision with trees.Jun 13, 1995 · N53340 · DestroyedNTSB NYC95LA132Accident · No injuriesLimited investigationFinal reportBeech 33 · Franklin Twp, PAThe pilot's improper planning/decision, his continued flight into adverse weather conditions, and his delay in reversing course (diverting to a new destination). The adverse weather with thunderstorms was a related factor.Jun 12, 1995 · N943T · Substantial damageNTSB LAX95LA208Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe pilot's improper recovery from a bounced landing. His misjudgment of the height above the runway during flare was a factor.Jun 12, 1995 · N73927 · Substantial damageNTSB FTW95FA238Accident · 1 fatalField investigationFinal reportSmith LONG-EZ · Cloudcroft, NMThe pilot's failure to maintain clearance from trees. Factors were the pilot exceeded the allowable maximum gross weight of the airplane, the rising terrain, and high density altitude.Jun 12, 1995 · N86PD · DestroyedNTSB ANC95LA077Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuntutuliak, AKThe airport maintenance personnel's inadequate maintenance of the runway by not replacing the yellow cones that marked the soft area. The soft area on the runway was a related factor.Jun 12, 1995 · N710WS · Substantial damageNTSB ANC95LA075Accident · Minor injuriesLimited investigationFinal reportHughes 500D · Ketchikan, AKAn air leak at a 'b' nut fitting on a pneumatic pc tube to the power turbine governor. Company maintenance personnel did not detect a leak after performing maintenance on the governer and P2 air line.Jun 12, 1995 · N549SW · Substantial damageNTSB SEA95LA117Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Challis, IDInadequate preflight/planning preparation. Factors to the accident were: downdraft and tailwind.Jun 11, 1995 · N7142M · Substantial damageNTSB MIA95LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Miami, FLTotal blockage of the air induction at the servo fuel injector by paper from an undetermined source and inadequate maintenance servicing by other maintenance personnel. Contributing to the accident was unsuitable terrain encountered by the pilot during the…Jun 11, 1995 · N7631S · Substantial damageNTSB LAX95LA207Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Fall River Mill, CAFatigue failure of the No. 2 lower connecting rod bolt as a result of improper torque during the last engine overhaul.Jun 11, 1995 · N5436Y · DestroyedNTSB LAX95LA206Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lebec, CAFuel exhaustion due to the pilot's lack of familiarity with the airplane's fuel sysytem and his failure to maintain an adequate supply of fuel to complete the flight.Jun 11, 1995 · N16081 · Substantial damageNTSB FTW95LA235Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Weatherford, TXThe pilot's failure to maintain control during landing resulting in the tail rotor blades striking the ground and separating, and the subsequent loss of directional (anti-torque) control. A factor was the uphill terrain.Jun 11, 1995 · N9074Y · Substantial damageNTSB FTW95IA243Incident · No injuriesIncident investigationFinal reportCessna 150L · Levelland, TXThe failure of the pilot of the other aircraft to maintain clearance during a formation flight. A factor was the lack of experience in the type of operation.Jun 11, 1995 · N10964 · 2 aircraft · Minor damageNTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.Jun 11, 1995 · N23477 · Substantial damageNTSB BFO95LA063Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Ft Washington, MDA loss of engine power for an undetermined reason(s).Jun 11, 1995 · N1775B · DestroyedNTSB BFO95LA062Accident · 1 fatalLimited investigationFinal reportBerg Steen Skybolt · Bath, NYthe pilot's failure to maintain sufficient altitude/clearance to avoid trees while performing aerobatic maneuvers. Related factors are the low altitude at which the maneuver was initiated and the delayed recovery/pull-up.Jun 11, 1995 · N3753B · DestroyedNTSB BFO95LA061Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Oxford, CTthe pilot's failure to maintain sufficient altitude/clearance from terrain. The low ceiling was a related factor in the accident.Jun 11, 1995 · N79175 · Substantial damageNTSB ANC95LA074Accident · Serious injuriesLimited investigationFinal reportChampion 11BC-S · Anchorage, AKThe pilot's improper compensation for the wind conditions. Factors associated with the accident are gusty winds and associated downdrafts.Jun 11, 1995 · N86135 · Substantial damageNTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.Jun 11, 1995 · N139F · Substantial damageNTSB ANC95LA069Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Tyonek, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven sandbar.Jun 11, 1995 · N9622V · Substantial damageNTSB MIA95WA150Accident · No injuriesForeign investigationMaule M-7-235 · Cat Cay, BahamasJun 10, 1995 · N3093N · Substantial damageNTSB MIA95LA168Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK 6C · Arcadia, FLInadequate preflight of the helicopter by the pilot-in-command by failure to assure adequate fuel for the flight. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Jun 10, 1995 · N9034T · Substantial damageNTSB LAX95LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Bear, CAthe pilot's failure to maintain directional control during an aborted takeoff attempt, which was necessitated by his failure to properly lean the fuel mixture. The pilot's limited experience in small piston engine airplanes was a factor in the accident.Jun 10, 1995 · N739NN · Substantial damage