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 NYC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to recover from a stall. Factors related to the accident were: the pilot's lack of total experience and excessive gross weight of the airplane.NTSB MIA90FA081Accident · 2 fatalField investigationFinal reportAerospatiale 350D · Miami, FLFatigue failure of an engine turbine blade, which resulted in a loss of power. Rough ocean water in the emergency landing area was a related factor.NTSB FTW90FA079Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe CFI pilot failed to maintain flying speed, and the resultant inadvertent stall. Contributing to the accident was the existing low ceiling.NTSB ATL90FA074Accident · 1 fatalField investigationFinal reportPiper PA-30 · Dayton, TNThe pilot's intentional use of an autopilot with known deficiencies. The pilot knowingly relied on this autopilot which malfunctioned in flight and resulted in his becoming spatially disorientated.NTSB MIA90LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Juan, PRFailure of the student pilot to maintain directional control of the aircraft while taxiing.NTSB MIA90LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and loss of aircraft control. Factors related to the accident were: the gusty crosswind, and failure of the pilot to maintain runway alignment.NTSB MIA90LA079Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Boca Raton, FLImproper remedial action by the pilot. A factor related to the accident was: loss of engine power in the right engine due to an undetermined reason.NTSB DEN90LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Alamogordo, NMThe collapse of the right main landing gear as a result of the malfunction of the down lock assembly and failure of the torque tube bracket assembly.NTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.NTSB MKC90LA061Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARFailure of the engine exhaust valve.NTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.NTSB LAX90LA110Accident · No injuriesLimited investigationFinal reportCessna 208B · Lanai, HIThe pilot's misjudgement of the glide path angle while executing a forced landing at the Lanai airport. Contributing to the accident was the failure of the pilot to properly secure the oil filter cap prior to departure.NTSB LAX90DVM02Accident · Minor injuriesFinal reportLink VARI-EZE · Hollister, CAThe pilot's misjudgement of altitude and distance to the runway, while on final approach to land. The sunglare was a related factor.NTSB DEN90IA072Incident · No injuriesIncident investigationFinal reportCessna 208A · Wright, WYThe incident was engine failure due to gas producer turbine disc blade failure caused by stress rupture.NTSB ATL90FA073Accident · No injuriesField investigationFinal reportMBB BO-105S · Benton, ALThe pilot-in-command's inadequate visual lookout. The incorrect wire survey given by the highway patrol personnel was a related factor.NTSB ANC90LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKImproper installation of the gear axle (use of improper bolts & the wrong number of shims), which resulted in a subsequent failure and loss of control during the landing roll.NTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.NTSB MIA90LA082Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alligator, MSEngine failure due to undetermined reasons resulting in the forced landing.NTSB MIA90LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mattson, MSThe no. 6 cylinder which cracked across the top from one spark plug hole to the other, resulting in the loss of engine power.NTSB ANC90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nome, AKThe failure of the left gear axle due to corrosion and fatigue.NTSB MKC90LA060Accident · No injuriesLimited investigationFinal reportCessna 140 · Brinkley, ARRecovery from bounced landing not performed and porpoise encountered by the pilot in command.NTSB FTW90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T50-A17 · Brackettville, TXAn engine failure caused by a malfunctioning carburetor and the pilot's misjudging his obstacle clearance which resulted in a wire strike while maneuvering to land. Factors in the accident were the uncommanded deployment of carburetor heat on both engines, an…NTSB FTW90LA076Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Mesquite, TXThe flight instructor's (cfi's) poor planning/decision, and his inadequate supervison of flight.NTSB FTW90FA077Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Fabens, TXThe pilot's failure to maintain adequate airspeed during a takeoff with less than full power resulting in a stall. Contributing factors were the pilot's failure to lean the mixture to compensate for the high density altitude, and the gross improper,…NTSB DEN90LA070Accident · 1 fatalLimited investigationFinal reportChampion 7EC · Pine Ridge, SDThe failure of the pilot to maintain an adequate airspeed, after diverting his attention, which resulted in an inadvertent stall.NTSB CHI90LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · Grygla, MNThe pilot's inadequate preflight preparation/planning, and subsequent fuel exhaustion due to an inadequate supply of fuel. The light condition at dusk, icy terrain (road) and tree were related factors.NTSB ATL90LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Rockingham, NCPilot's failure to maintain directional control while attempting a landing.NTSB ATL90FA071Accident · Serious injuriesField investigationFinal reportPiper PA-28-151 · Creola, ALThe pilot's failure to assure that proper maintenance and inspection of the aircraft were completed before flight.NTSB NYC90LA074Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, MAAn off airport landing in unsuitable terrain following a power loss due to a delaminated ceet duct between the air intake screen and carburetor air box.NTSB MKC90LA059Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · El Dorado, ARFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind.NTSB MIA90LA077Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miami, FLInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The location of trees was a related factor in that the pilot was unable to maintain rotor RPM while attempting to reach a suitable landing area during…NTSB LAX90LA109Accident · 1 fatalLimited investigationFinal reportCameron O-105 · Phoenix, AZImproper modification of the balloon's fuel/heater system by the owner/operator and failure of the fuel line connection, which resulted in a fuel system leak and gondola (basket) fire.NTSB DEN90LA069Accident · No injuriesLimited investigationFinal reportErco 415C · Tierra Amarilla, NMInduction icing induced power loss. Factors include continuation of flight into IMC conditions, and unsuitable mountainous terrain for a forced landing.NTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.NTSB CHI90LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Brainerd, MNThe failure of the pilot to maintain proper alignment with the runway.NTSB ATL90LA072Accident · No injuriesLimited investigationFinal reportCessna 172G · Wanchese, NCThe pilot's premature, discontinued use of carburetor heat.NTSB ATL90LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Canon, GAImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions, and soft terrain.NTSB SEA90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Valmy, NVThe pilots poor inflight planning and decision to land on an abandoned highway in strong gusty crosswind conditions, his improper remedial action of turning downwind at a low altitude after aborting the landing and his failure to maintain airspeed. Factors in…NTSB SEA90FA074Accident · 2 fatalField investigationFinal reportPiper PA28R-200 · Prairie City, ORUncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.NTSB MIA90LA076Accident · No injuriesLimited investigationFinal reportHughes 300C · Vero Beach, FLThe failure of the pilot in command/instructor pilot to maintain adequate rotor RPM after landing from a touchdown autorotation. A factor related to the accident was the gusty wind condition.NTSB MIA90LA075Accident · Minor injuriesLimited investigationFinal reportZimmerman Varieze · Brooksville, FLLoss of engine power for undetermined reasons during the initial climb shortly after takeoff.NTSB SEA90LA048Accident · Minor injuriesLimited investigationFinal reportBell BH-47G3B2 · Des Moines, WAPartial loss of engine power, cause undetermined. The aircraft was not recovered and examination of the engine was not possible.NTSB MKC90LA058Accident · No injuriesLimited investigationFinal reportCessna 195 · Garden City, KSDirectional control not maintained by the pilot in command.NTSB MKC90FA057Accident · 1 fatalField investigationFinal reportBeech B36TC · Inver Grove Hgt, MNPremature lift-off by the pilot, while taking off with a heavy gross weight in unfavorable winds, and the pilot's failure to attain/maintain adequate airspeed, which resulted in an inadvertent stall/mush.NTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.NTSB LAX90LA107Accident · No injuriesLimited investigationFinal reportBeech B-19 · Chiriaco Summit, CAA engine compartment fire of undetermined origin dduring engine start.NTSB FTW90LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Tomball, TXThe pilot in command's inaccurate fuel consumption calculations, which resulted in loss of engine power due to fuel exhaustion. Factors in this accident were: the dark night, and the soft/wet terrain.NTSB DEN90FA068Accident · 1 fatalField investigationFinal reportCessna 208A · Denver, COThe accumulation of structural ice and subsequent stalling of the aircraft. The icing condition was a related factor.NTSB CHI90LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILPilot's inability to maintain directional control of the aircraft during the touchdown and landing roll phases of flight, due to deposits of slush frozen on the left landing gear brake.NTSB SEA90LA046Accident · No injuriesLimited investigationFinal reportCessna 182K · Sheridan, ORThe loss of engine power due to the inadequate preflight inspection of the aircraft by the pilot in command.