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 CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.NTSB ATL00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Key West, FLA landing gear collapse resulting from the pilot's unsuccessful attempt to complete the manual gear extension due to physical strength overload. A factor was the complete electrical system failure during cruise flight.NTSB ATL00LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Loss of engine power for undetermined reasons. A factor was the pilot failed to use carburetor heat during the descent.NTSB ANC00LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the presence of a tailwind, the pilot's inadvertent touchdown, and a short landing area bordered by high vegetation.NTSB ANC00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe failure of the pilot to maintain directional control of the airplane during takeoff.NTSB SEA00LA112Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Boardman, ORThe pilot's failure to maintain adequate airspeed through an area of turbulence, resulting in entry into a stall/mush condition. Factors included tailwind conditions, trees at the end of the runway, terrain-induced turbulence, and crops near the airstrip.NTSB NYC00LA174Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Springdale, OHThe pilot's inadequate preflight of the helicopter, and his subsequent failure to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain.NTSB MIA00FA190Accident · 4 fatalField investigationFinal reportLearjet 55 · Boca Raton, FLThe failure of the pilot's of both airplanes to maintain a visual lookout (while climbing and maneuvering) resulting in an in-flight collision and subsequent collision with residences and terrain.NTSB LAX00LA241Accident · No injuriesLimited investigationFinal reportCessna 206 · Gerlach, NVThe pilot's attempt to takeoff from an unsuitable area and his collision with a dirt berm.NTSB LAX00LA240Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26C · Tehachapi, CAThe pilot's failure to maintain aircraft speed and control while maneuvering to land.NTSB LAX00LA239Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Arbuckle, CAthe partial failure of the tail rotor pitch change control rod that resulted in an attempted run-on landing in dark night conditions.NTSB IAD00FA053Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bealeton, VAthe flight instructor's improper pre-flight plan and decision to land and depart an airport with insufficient runway. A factor in the accident was the short grass runway with a 100-foot obstruction at the end.NTSB DEN00LA117Accident · No injuriesLimited investigationFinal reportBeech M35 · Los Alamos, NMThe pilot's misjudgment of distance/speed resulting in an overrun and subsequent collision with a blast fence. Contributing factors were high density altitude, a tailwind, and the blast fence.NTSB CHI00LA169Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, ILthe student pilot failed to properly flare the airplane while landing. A factor associated with the accident was the student pilot's lack of total experience.NTSB ATL00LA067Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Tylertown, MSLoss of directional control due to separation of the tail-wheel spring assembly. A factor was the ditch which run adjacent to the runway.NTSB ANC00TA075Accident · No injuriesFinal reportPiper PA-18 · Quinhagak, AKThe pilot's inadequate compensation for wind conditions during takeoff. Factors associated with the accident were the sudden windshift from a crosswind to a tailwind.NTSB ANC00LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident is the pilot's excessive use of the brakes.NTSB ANC00FA076Accident · 1 fatalField investigationFinal reportCessna 172N · Tuntutuliak, AKThe pilot's disregard of the existing wind conditions, and an inadvertent stall. Factors associated with the accident are a tailwind, and wind gusts.NTSB SEA00LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Wallace, IDThe pilot's failure to maintain airspeed and his failure to maintain clearance from the trees. Related factors were trees and mountainous terrain.NTSB NYC00LA176Accident · Minor injuriesLimited investigationFinal reportSchwarz Avid Amphibian · Fredericksburg, VAA failure of the propeller reduction gear assembly for undetermined reasons, which resulted in a loss of thrust.NTSB LAX00LA260Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Ana, CAThe loss of engine power during the initial takeoff climb, at too low an altitude to afford remedial action, because of an ingested valve, and the airplane's subsequent collision with the ground adjacent to the runway.NTSB ANC00LA074Accident · Minor injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe inadequate visual lookout by the pilot of the other airplane, and the inadequate radio traffic advisories by the pilots of both airplanes.NTSB SEA00LA111Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Mountain Home, IDThe pilot's decision to takeoff in unfavorable weather conditions without first calculating takeoff performance data. Factors include gusty winds, downdrafts, terrain-induced turbulence, and rough/uneven terrain where the pilot elected to make the…NTSB SEA00LA110Accident · 2 fatalLimited investigationFinal reportHoye Kolb Twinstar MK III · Bigfork, MTThe pilot's failure to maintain aircraft control. Inadequate altitude for recovery was a factor.NTSB MIA00TA189Accident · Serious injuriesFinal reportBell OH-58 · Rome, GAThe pilots failure to ensure the helicopter was on level terrain after landing. The left skid came off the ground after the passenger exited the helicopter, the slope capability was exceeded, the helicopter encountered dynamic rollover, and rolled over on its…NTSB LAX00LA238Accident · No injuriesLimited investigationFinal reportWard Sidewinder · Madera, CAThe pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.NTSB LAX00LA237Accident · No injuriesLimited investigationFinal reportCessna 150M · El Monte, CAThe inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…NTSB FTW00LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ben Wheeler, TXThe pilot's inadvertent stall of the aircraft.NTSB DEN00LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Orchard, COThe pilot inadvertently stalling the airplane. A factor was his failure to maintain sufficient airspeed.NTSB ATL00LA065Accident · No injuriesLimited investigationFinal reportBeech 19B · Tampa, FLThe loss of engine power for undetermined reasons. A factor was the weather conditions were favorable for the formation of carburetor ice. Contributing to the severity of the accident was the pilots lack of experience in the airplane which led to an…NTSB ANC00LA073Accident · Minor injuriesLimited investigationFinal reportBlanc Glastar · Northway, AKThe pilot's continued flight into known adverse weather. A factor associated with the accident were low clouds.NTSB ANC00LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fatigue failure of the left main landing gear leg at the main landing gear axle attachment bolt holes.NTSB LAX00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Selma, CAThe pilot's inadequate preflight planning that resulted in fuel exhaustion and subsequent collision with grapevines during an off airport forced landing.NTSB ANC00GA071Accident · 4 fatalFinal reportCessna 185E · Talkeetna, AKThe pilot's continued flight into known adverse weather conditions and subsequent in-flight break-up. Factors in the accident were weather conditions consisting of low ceilings, turbulence, and an occluded front with convective activity, and inadequate…NTSB NYC00LA173Accident · No injuriesLimited investigationFinal reportFleet 16B · Rochester, NHThe pilot's failure to maintain directional control. A factor in the accident was the pilot's lack of experience in the accident airplane make and model.NTSB NYC00LA171Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Warren, VTThe pilot's inadequate compensation for crosswind conditions. A factor in the accident was the cross wind.NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB LAX00LA234Accident · 1 fatalLimited investigationFinal reportBeech G35 · Byron, CAin-flight loss of control and inadvertent stall.NTSB FTW00LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXLoss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA181Accident · Minor injuriesLimited investigationFinal reportBell 206B · Deville, LAthe pilot's failure to maintain clearance with the external load that was setting on the ground while hovering. A contributing factor was the pilot's diverted attention.NTSB DEN00LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Abuquerque, NMThe pilot's improper flare and his inadequate recovery from a bounced landing.NTSB SEA00LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Vancouver, WAThe pilot's failure to determine the aircraft's airworthiness before flight, resulting in operation of the aircraft in an unairworthy condition and consequent fuel starvation, and his subsequent failure to maintain adequate airspeed in an emergency turn back…NTSB NYC00LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Cheswold, DEThe instructor's delayed remedial action. Factors included the instructor's failure to take positive control of the airplane, and the student's failure to maintain adequate airspeed during the approach.NTSB DCA00WA094Incident · No injuriesForeign investigationBoeing B-767-200 · Addis Ababa, EthiopiaNTSB CHI00LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Decatur, ILthe pilot's failure to maintain clearance with the T-hangar while taxiing. A Factor associated with the accident was the pilot's attention was diverted to an other airplane which was taxiing on the same taxi line in the opposite direction.NTSB CHI00LA167Accident · Serious injuriesLimited investigationFinal reportRans Employee Flying Club Rans S-12 XL · Prairie Du Sac, WIA loss of engine power due to fuel starvation as a result of an obstructed fuel nozzle.NTSB CHI00FA165Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Westfield, INThe pilot's improper in-flight decison to maneuver back to the departure airport following the loss of engine power on initial climb, the pilot's loss of aircraft control and the pilot's inadequate preflight inspection of the airplane. Contributing factors to…NTSB SEA00LA107Accident · 1 fatalLimited investigationFinal reportHaessler Cosmo Phase II · Banks, ORThe pilot's improper installation, i.e., reversed connection, of the rudder control cables resulting in reverse rudder operation and a subsequent stall/spin. A contributing factor was the pilot's intentional design change/addition of a rudder to the aircraft.NTSB SEA00IA108Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73 · Seattle, WAAuxiliary hydraulic pump leak resulting in a failure of the hydraulic system.NTSB NYC00LA168Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Turner, METhe pilot's failure to maintain directional control after landing. A factor in this accident was the high grass along the runway edge which disguised an embankment.