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 LAX92LA295Accident · No injuriesLimited investigationFinal reportRobinson R-22BETA · Paso Robles, CAThe pilot's failure to maintain adequate clearance between the helicopter and the terrain while hover taxing.NTSB LAX92FA294Accident · 1 fatalField investigationFinal reportBell 206B · Twin Peaks, CAWas the pilot's decision to initiate the flight in known adverse weather and continued VFR flight into instrument meteorological conditions. Contributing to this accident was the low clouds and fog.NTSB CHI92LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Ortonville, MIImproper use of the fuel tank selector switch and inadequate emergency procedures by the pilot in command.NTSB BFO92LA096Accident · No injuriesLimited investigationFinal reportBeech A35 · Toms River, NJThe pilot's failure to maintain directional control during landing.NTSB ATL92LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Goldsboro, NCThe failure of the pilot to maintain directional control of the aircraft during taxi.NTSB ATL92LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, ALThe failure of the pilot to maintain directional control of the aircraft as a result of his lack of total experience.NTSB ANC92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kugururak River, AKThe failure to maintain directional control during takeoff. Factors include rough/uneven terrain.NTSB CHI92DER02Accident · No injuriesFinal reportPiper PA-25-235 · Badger, MNThe pilot's failure to maintain aircraft control while maneuvering at low altitude in gusty winds.NTSB CHI92DCJ04Accident · No injuriesFinal reportCallair A-9 · Beaver City, NEThe inadequate maintenance overhaul of the left magneto, and subsequent failure of the left magneto/ignition system which caused a complete loss of engine power.NTSB ANC92LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Molly Creek, AKThe pilot misjudged his terrain clearance when planning his takeoff. Factors include high vegetation at the end of the runway.NTSB SEA92FA147Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Woods Cross, UTPilot factor in that he failed to attain and maintain sufficient flying speed. Factors to the accident were: cylinder over temperature, improper use of the mixture and procedures/directives were not followed.NTSB MIA92T#A02Accident · No injuriesClass 3Final reportHughes 269C · Jacksonville, FLNTSB MIA92LA151Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4-200 · FLSubstantial damage to the airplane during Unknown phase of flight for undetermined reasons.NTSB LAX92LA290Accident · Serious injuriesLimited investigationFinal reportWhigham GW-4 · Warner Springs, CAThe pilot's inadequate preflight planning and preparation. Contributing to this accident was the downdrafts and mountainous terrain.NTSB LAX92FA289Accident · 1 fatalField investigationFinal reportCessna T210N · Superior, AZAn inadequate major engine overhaul procedure, during which previous crankshaft damage was not detected. Contributing to the accident was a surface initiated fatigue failure of the engine crankshaft.NTSB FTW92DPG08Accident · No injuriesFinal reportGrumman G-164A · Grady, ARLoss of engine power due to a failed cylinder. A factor was the unsuitable terrain.NTSB CHI92LA202Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILThe student pilot's failure to maintain airplane directional control. Related factors are the student's lack of total flight experience, and improper aircraft control.NTSB CHI92DEX02Accident · No injuriesFinal reportTownsend-Snyder Rultan Varieze · Indianapolis, INFuel starvation due to improper fuel tank selection.NTSB CHI92DCQ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Scott City, KSThe failure of the pilot in command to maintain sufficent airspeed for flight resulting in an inadvertent stall.NTSB BFO92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chestertown, MDCarburetor ice, due to the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and obstructions (houses and utility pole) in the emergency landing area.NTSB BFO92LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Clay City, KYFuel starvation for an undetermined reason. Darkness and trees in the emergency landing area were related factors.NTSB BFO92FA095Accident · 1 fatalField investigationFinal reportAeronca 7EC · Slatington, PAThe loss of control in flight for undetermined reasons which resulted in an inadvertent stall at an altitude insufficient for recovery.NTSB BFO92FA094Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Concord, NHLoss of control during flight for undetermined reason(s).NTSB BFO92FA093Accident · 1 fatalField investigationFinal reportCessna U206F · Portland, MEImproper in-flight planning/decision by the pilot, resulting in fuel starvation due to improper positioning of the fuel selector. Factors related to the accident were: an undetermined electrical failure, and loss of fuel quantity indication.NTSB SEA92FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Pierce, IDInflight loss of control when aircraft control was not maintained. Factors to the accident were: flight into known adverse weather and thunderstorm activity.NTSB LAX92LA291Accident · No injuriesLimited investigationFinal reportCessna 210 · Truckee, CAThe pilot's improper flare.NTSB LAX92LA288Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Van Nuys, CAThe second pilot's improper use of the rotorcraft flight controls and the first pilot's poor supervision of the flight. A factor relating to this accident was both pilot's inexperience in the helicopter make and model.NTSB FTW92LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Granbury, TXThe pilot's improper flare during landing and his improper recovery from a bounced landing.NTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.NTSB FTW92DPG07Accident · No injuriesFinal reportAyres S2R · Grady, ARThe loss of engine power due to the separation of the number one engine cylinder. A factor was the unsuitable terrain.NTSB DEN92IA072Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Lamar, COFractured nose landing gear bolt due to fatigue.NTSB CHI92DCG03Accident · Minor injuriesFinal reportDaniel M. Dent BD-5 B · Ft. Levenworth, KSA complete loss of engine power following an electrical short to ground in the aircraft's 'ignition kill' electric circuit.NTSB SEA92LA146Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melstone, MTInadequate in flight planning/decision. Factors to the accident were: unsuitable terrain was selected, rough/uneven terrain and a go around was not performed.NTSB MIA92LA147Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180 · Okeechobee, FLThe failure of the pilot-in-command of N148DP to obtain NOTAM information concerning military routes along his route of flight, resulting in his encounter with a flight of F16 aircraft who were operating on a military route.NTSB FTW92LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Grove, OKThe pilot failed to maintain aircraft contyrol. A factor was turbulence.NTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.NTSB CHI92LA203Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Harvard, ILThe pilot's failure to understand wind information as presented by the windsock, selecting the wrong runway for landing, and delaying the aborted landing.NTSB CHI92FA201Accident · 4 fatalField investigationFinal reportCessna 172N · St Paul, MNInadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid conflicting traffic, and failure of the relieving controllers to use the radar display to identify and sequence an airplane entering the pattern.…NTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.NTSB BFO92LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, CTThe loss of engine power due to a cracked cylinder and the inadvertent aerodynamic stall that occurred during the precuationary landing.NTSB SEA92LA145Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Driggs, IDThe pilot in command's failure to insure adequate clearance. Factors contributing to the accident were: weather condition (downdraft) and object (transmission wires).NTSB FTW92DPG06Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARLoss of engine power. A factor was the lack of suitable terrain for forced landing.NTSB BFO92LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Frederick, MDThe pilot's improper use of carburetor heat resulting in the formation of carburetor ice. Carburetor icing weather conditions was a factor.NTSB BFO92FA088Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Bowling Green, KYThe loss of control in flight due to spatial disorientation/vertigo.NTSB LAX92LA282Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague, CAThe disintegration of the left wheel during the landing roll out and the resultant inability of the pilot to maintain directional control of the aircraft. A factor in the accident was the soft nature of the terrain encountered by the aircraft after leaving…NTSB LAX92LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Agua Caliente, CAThe failure of the pilot to maintain an adequate approach airspeed and an inadvertent stall/mush condition which resulted in a collision with the ground short of the runway. A factor in the accident was the pilots lack of total experience in type of aircraft.NTSB LAX92LA280Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Barstow, CA1) The pilot's maneuvering at low altitude into a tailwind condition which exceeded the performance capabilities of the helicopter, 2) his failure to maintain proper main rotor RPM, and 3) the pilot's selection of an altitude for the maneuvers which was too…NTSB LAX92LA279Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Shelter Cove, CAThe pilot's inadequate preflight inspection of the aircraft and his failure to ensure that the control surface locks were removed prior to flight.NTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.NTSB CHI92LA198Accident · 1 fatalLimited investigationFinal reportCessna 177B · Dwight, ILThe passenger's inattention to the propeller arc and the pilot's improper procedure in disembarking a passenger while the engine was running.