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 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.Jul 11, 1992 · N2316H · Substantial damageNTSB 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.Jul 11, 1992 · N59484 · DestroyedNTSB 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.Jul 11, 1992 · N6617V · Substantial damageNTSB BFO92LA096Accident · No injuriesLimited investigationFinal reportBeech A35 · Toms River, NJThe pilot's failure to maintain directional control during landing.Jul 11, 1992 · N8851A · Substantial damageNTSB ATL92LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Goldsboro, NCThe failure of the pilot to maintain directional control of the aircraft during taxi.Jul 11, 1992 · N6480W · Substantial damageNTSB 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.Jul 11, 1992 · N9768T · Substantial damageNTSB ANC92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kugururak River, AKThe failure to maintain directional control during takeoff. Factors include rough/uneven terrain.Jul 11, 1992 · N9961D · Substantial damageNTSB CHI92DER02Accident · No injuriesFinal reportPiper PA-25-235 · Badger, MNThe pilot's failure to maintain aircraft control while maneuvering at low altitude in gusty winds.Jul 10, 1992 · N4704Y · DestroyedNTSB 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.Jul 10, 1992 · N9627Z · Substantial damageNTSB 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.Jul 10, 1992 · N3997Z · Substantial damageNTSB 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.Jul 9, 1992 · N9323P · DestroyedNTSB MIA92T#A02Accident · No injuriesClass 3Final reportHughes 269C · Jacksonville, FLJul 9, 1992 · N8957F · DestroyedNTSB MIA92LA151Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4-200 · FLSubstantial damage to the airplane during Unknown phase of flight for undetermined reasons.Jul 9, 1992 · N2969P · Substantial damageNTSB 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.Jul 9, 1992 · N3705 · Substantial damageNTSB 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.Jul 9, 1992 · N6483C · DestroyedNTSB FTW92DPG08Accident · No injuriesFinal reportGrumman G-164A · Grady, ARLoss of engine power due to a failed cylinder. A factor was the unsuitable terrain.Jul 9, 1992 · N48495 · Substantial damageNTSB 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.Jul 9, 1992 · N98673 · Substantial damageNTSB CHI92DEX02Accident · No injuriesFinal reportTownsend-Snyder Rultan Varieze · Indianapolis, INFuel starvation due to improper fuel tank selection.Jul 9, 1992 · N40TS · Substantial damageNTSB 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.Jul 9, 1992 · N9635P · DestroyedNTSB 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.Jul 9, 1992 · N89577 · Substantial damageNTSB 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.Jul 9, 1992 · N2857D · DestroyedNTSB 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.Jul 9, 1992 · N7578B · DestroyedNTSB BFO92FA094Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Concord, NHLoss of control during flight for undetermined reason(s).Jul 9, 1992 · N220MA · DestroyedNTSB 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.Jul 9, 1992 · CGTCM · Substantial damageNTSB 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.Jul 8, 1992 · N23LB · DestroyedNTSB LAX92LA291Accident · No injuriesLimited investigationFinal reportCessna 210 · Truckee, CAThe pilot's improper flare.Jul 8, 1992 · N9652T · Substantial damageNTSB 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.Jul 8, 1992 · N5061F · Substantial damageNTSB FTW92LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Granbury, TXThe pilot's improper flare during landing and his improper recovery from a bounced landing.Jul 8, 1992 · N4046R · Substantial damageNTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.Jul 8, 1992 · N7315L · Substantial damageNTSB 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.Jul 8, 1992 · N4979X · Substantial damageNTSB DEN92IA072Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Lamar, COFractured nose landing gear bolt due to fatigue.Jul 8, 1992 · N3030K · Minor damageNTSB 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.Jul 8, 1992 · N583BD · Substantial damageNTSB 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.Jul 7, 1992 · N97046 · Substantial damageNTSB 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.Jul 7, 1992 · N148DP · Substantial damageNTSB FTW92LA177Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Grove, OKThe pilot failed to maintain aircraft contyrol. A factor was turbulence.Jul 7, 1992 · N3562J · Substantial damageNTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.Jul 7, 1992 · N3650N · Substantial damageNTSB 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.Jul 7, 1992 · N8056P · Substantial damageNTSB 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.…Jul 7, 1992 · N6376F · 2 aircraft · DestroyedNTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.Jul 7, 1992 · N820FL · Substantial damageNTSB 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.Jul 7, 1992 · N68215 · Substantial damageNTSB 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).Jul 6, 1992 · N1613B · DestroyedNTSB FTW92DPG06Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARLoss of engine power. A factor was the lack of suitable terrain for forced landing.Jul 6, 1992 · N8922H · Substantial damageNTSB 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.Jul 6, 1992 · N92668 · Substantial damageNTSB BFO92FA088Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Bowling Green, KYThe loss of control in flight due to spatial disorientation/vertigo.Jul 6, 1992 · N188AL · DestroyedNTSB 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…Jul 5, 1992 · N592C · Substantial damageNTSB 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.Jul 5, 1992 · N78669 · Substantial damageNTSB 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…Jul 5, 1992 · N2321R · Substantial damageNTSB 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.Jul 5, 1992 · N929DB · DestroyedNTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.Jul 5, 1992 · N36133 · Substantial damageNTSB 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.Jul 5, 1992 · N35107 · No damage