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 CHI89DEK02Accident · No injuriesFinal reportKeener Rotorway/Exec · Circleville, OHMaterial failure of an oil line allowing oil to escape and ignite as it touched hot exhaust manifold surfaces.NTSB ATL89LA192Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Dunn, NCThe pilot's failure to properly calculate the takeoff distance required for the conditions and the airplane collided with power lines during climbout.NTSB ATL89LA191Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Gaines, GAThe pilot failed to maintain directional control of the airplane during takeoff, which resulted in a collision with trees adjacent to the runway.NTSB ANC89LA134Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Chitina, AKThe pilot's failure to maintain airspeed during climb out, which resulted in the acft stalling and impacting the terrain.NTSB ANC89FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Anchorage, AKLoss of engine power for an unknown reason, and the pilot's failure to maintain adequate airspeed, while turning back toward the airport, which resulted in an inadvertent stall/spin.NTSB NYC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Barker, NYThe pilot's decision to abort the landing too FAR down the runway. A factor was: the small tree located off the end of the runway.NTSB NYC89LA192Accident · No injuriesLimited investigationFinal reportCessna R172K · Griswold, CTImproper flare by the pilot, and his failure to attain adequated airspeed for an aborted landing (go-around), which resulted in a loss of aircraft control.NTSB NYC89LA186Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Shirley, NYThe failure of the pilot to maintain proper airspeed, and his delay to jettison the banner, which resulted in a stall.NTSB MIA89LA243Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Hollywood, FLThe severe fuselage vibration (ground resonance) and the pilot's improper planning/decision to avoid or compensate for the occurrence. A factor related to the accident was the low shock strut.NTSB MIA89LA215Accident · No injuriesLimited investigationFinal reportCessna 188 · Canton, MSThe pilot's attempted flight in known adverse weather conditions. Factors related to the accident were: adverse weather conditions and the presence of the parked aircraft near the runway.NTSB MIA89LA213Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Sarasota, FLThe student pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the student pilot's lack of total experience & tree(s) in the emergency landing area.NTSB MIA89FA214Accident · 1 fatalField investigationFinal reportCessna 210L · Marco, FLContinued VFR flight by the pilot into instrument meteorological conditions (IMC), his misjudgment of altitude and his physical impairment from use of drugs. Contributing factors were: the pilot's probable spatial disorientation, and the night/weather…NTSB LAX89LA264Accident · No injuriesLimited investigationFinal reportCessna 182 · Parker Dam, CAThe pilot's delay in making a go-around, and his failure to maintain clearance from the terrain during the aborted landing. The runway/terrain condition was a related factor.NTSB FTW89LA144Accident · No injuriesLimited investigationFinal reportCessna 172G · Mckinney, TXTotal failure of the engine assembly/rocker arm/tappet shaft.NTSB FTW89FA143Accident · 1 fatalField investigationFinal reportBalloon Works Firefly 6B · Baton Rouge, LAThe pilot exceeded the temperature limitations of the Balloon during the climb, which resulted in failure of the frabric. Factors related to the accident were: the previous heat damage to the frabric, and the lack of maintenance by the pilot/owner.NTSB DEN89LA191Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COThe student pilot failed to maintain directional control during landing roll due to improper use of the flight controls.NTSB DEN89LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ruidoso, NMThe pilot's improper use of the mixture control and carburetor heat during a takeoff in high density altitude conditions. Contributing to the accident was the high density altitude.NTSB CHI89LA161Accident · No injuriesLimited investigationFinal reportCessna R172K · Vincennes, INThe pilot had excessive airspeed, misjudged the landing distance, and did not go around. Contributing factors were: the pilot misread wind information and selected the wrong runway. Also, the tailwind and ditch were considered to be contributing factors.NTSB ANC89LA135Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kodiak, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop.NTSB NYC89LA189Accident · Minor injuriesLimited investigationFinal reportConvair CV-600-240D · Augusta, METhe failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…NTSB MKC89LA176Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sebeka, MNPower plant failure due to a fracture of the first stage turbine wheel, resulting in an uncontrolled autorotation.NTSB LAX89LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-180 · Lancaster, CAThe pilot's failure to follow established procedures in restarting the engine that drives the hydrualic pump and his failure to follow published emergency landing gear extension procedures. The pilot's decision to shut down an engine and feather the propeller…NTSB LAX89LA261Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rio Linda, CAFailure of the pilot to maintain proper runway alignment during an aborted landing. Related factors were: a false airspeed indication, the pilot's lack of familiarity with the aircraft, his improper use of carburetor heat, his diverted attention, and the…NTSB DEN89LA183Accident · No injuriesLimited investigationFinal reportCessna 177RG · Brighton, COFailure of the landing gear down lock, which allowed the landing gear to collapse during the landing.NTSB CHI89LA163Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Putnam, ILImproper use of carburetor heat by the pilot which resulted in reduced power for takeoff. The obstructions (hangar & trees) and weather conditions were contributing factors.NTSB CHI89LA159Accident · No injuriesLimited investigationFinal reportCessna 170A · Brookfield, WIThe pilot-in-command's failure to take proper corrective action after encountering a wind gust on landing.NTSB ANC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Canyon Creek, AKThe pilot's improper planning/decision concerning fuel management, which resulted in fuel starvation. Contributing factors were: probable water in the fuel, inadequate altitude for an engine restart, and the terrain conditions.NTSB NYC89LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Mattituck, NYFailure of right braking action due to a hydraulic leak.NTSB MIA89WA212Accident · 1 fatalForeign investigationCessna 401 · Grand Turk Isl., Turks & Caicos IslandsNTSB MIA89LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Apalachicola, FLFailure of the pilot to maintain proper altitude. A factor related to the accident was: the pilot's lack of visual perception concerning altitude above the water.NTSB LAX89DUJ08Accident · No injuriesFinal reportAero Commander S2R · Tolleson, AZThe pilots failure to see and avoid contact with some wires.NTSB CHI89LA156Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILFailure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB CHI89FA157Accident · 1 fatalField investigationFinal reportCessna 152 · York, SCFailure of the pilot to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: excessive workload (task overload) and diverted attention.NTSB BFO89LA067Accident · No injuriesLimited investigationFinal reportTravel Air B-4000 · Midland, VAThe pilot's improper compensation for wind conditions and improper flare during the landing. Contributing factors were:the wind conditions and the pilot's lack of experience in this make and model of aircraft.NTSB ATL89FA189Accident · No injuriesField investigationFinal reportConvair 640 (340D) · Atlanta, GAPilot in command failed to place the airplane at a position from which a stabilized approach to landing could be made. His procedure for the recovery from the bounced landing was inadequate and the nose gear structural strength was exceeded during following…NTSB NYC89LA203Accident · No injuriesLimited investigationFinal reportCessna 172P · Newburgh, NYThe dual student's misjudgement of the airplane's altitude and speed during the flare for landing, and the improper use of power during the flare. In addition, the CFI failed to adequately supervise the dual student's action.NTSB NYC89LA180Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHLoss of directional control during an aborted takeoff. The ditch was a related factor.NTSB NYC89LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Philadelphia, PALoss of engine power for an unknown reason. A factor related to the accident was: water in the emergency landing area.NTSB MIA89FA210Accident · 2 fatalField investigationFinal reportBeech A24R · Sarasota, FLFailure of the propeller hub due to previous damage, which resulted in subsequent fatigue failure of the hub; and failure of the pilot to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection…NTSB LAX89LA259Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Palm Springs, CAThe pilot's failure to properly manipulate the throttle control to maintain engine/rotor RPM and his decision to enter an autorotation (forced landing). His eagerness to land and lack of total experience were factors in the accident.NTSB LAX89LA258Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fremont, CAThe pilot's improper inflight decison to land on an unlighted runway during the hours of darkness. Darkness and the lack of runway lights were related factors.NTSB FTW89LA142Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Littlefield, TXImproper planning/decision by the pilot & the severe turbulence.NTSB FTW89DRG04Accident · No injuriesFinal reportSchweizer G-164B · Austwell, TXPilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.NTSB CHI89LA158Accident · No injuriesLimited investigationFinal reportBeech S35 · Lindon, MIThe restricted movement of the ruddervator control due to undetermined reasons.NTSB CHI89DEX06Accident · No injuriesFinal reportGrumman G-164A · Sullivan, INA failure of the supercharger oil seal which resulted in a partial loss of engine power during takeoff and the uncontrolled touchdown during the forced landing. Factors related to the accident were: partial failure of the supercharger and spark plub fowling.NTSB CHI89DEM05Accident · Minor injuriesFinal reportGatzemeyer 88 ACRO-SPORT II · Escanaba, MIA loose fuel line between the carburetor and engine which resulted in fuel starvation. A factor related to the accident was: no suitable terrain.NTSB ATL89IA187Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Greensboro, NCFailure of the line mechanic, a check mechanic, and first officer to identify and remove the wheel chock from the wheel well during the required inspections.NTSB ATL89FA193Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13/M74 · Norman Park, GAImproper planning/decision by the pilot, which resulted in his physical impairment from exposure to lannate, and his failure to maintain altitude/clearance above the ground. A factor related to the accident was: failure of the pilot to use a respirator while…NTSB ATL89FA188Accident · 6 fatalField investigationFinal reportBeech 70 · Albany, GAThe fatigue failure of the supercharger intermediate drive gear shaft (gear tooth), which resulted in a partial loss of power, and the pilot's initiation of lift-off before reaching VMC airspeed. Factors related to the accident were: the worn intermediate…NTSB NYC89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danbury, CTThe pilot's misjudgement of (excessive) airspeed, his failure to attain the proper touchdown point, and failure to make a go-around, while there was sufficient runway remaining. The fence was a related factor.