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 NYC90LA085Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Hudson, NYThe pilots improper operation of the flight controls which resulted in the loss of control of directional control of the airplane during a touch and go landing. Factors related to the accident were the pilot's lack of total experience.NTSB FTW90FA092Accident · 1 fatalField investigationFinal reportErcoupe 415CD · Hereford, TXInadvertent stall. Factors were maximum gross weight exceeded by the pilot, the pilot's impairment due to drugs, and the pilot's lack of total experience.NTSB DEN90FA089Accident · 1 fatalField investigationFinal reportCessna 210E · Elbert, COThe pilot's initiation of flight into known adverse weather, the rapid ice accumulation on the airframe, and an inadvertent stall-mush, resulting in an uncontrolled descent into terrain.NTSB ATL90LA094Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Stone Mountain, GAThe pilot's misjudged approach which resulted in a long, fast landing and subsequent overrun of the departure threshold. Factors in the accident were the pilot's failure to lower the flaps and establish a proper glidepath.NTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.NTSB NYC90LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Bedford, MAFailure of the exhaust system and subsequent melting/shorting of the magneto p-leads.NTSB LAX90FA281Accident · 2 fatalField investigationFinal reportCessna 172E · Santa Paula, CAThe pilot's improper preflight planning and preparation and his delayed remedial action in executing a 180 degree turn. Contributing to this accident was the pilot's inadvertent encounter with weather conditions.NTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.NTSB CHI90LA110Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Lodge, ILFailure of the pilot to maintain directional control during takeoff. The crosswind and the soft/uneven terrain were factors related to the accident.NTSB CHI90LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Savanna, ILImproper planning/decision by the pilot. The strong/gusty crosswind was a related factor.NTSB BFO90LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lovingston, VAPilot failure to climb out of ground effect because of inadequate airspeed. Factor was unfavorable wind at takeoff.NTSB ANC90FA052Accident · No injuriesField investigationFinal reportAeronca 11AC · Chugiak, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind and snow covered terrain beside the runway.NTSB ANC90FA051Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot lost directional control during the landing roll as a result of improper braking.NTSB MIA90FA102Accident · 1 fatalField investigationFinal reportFarrington AIR Command 532 · Okeechobee, FLPilot's decision to attempt to fly the gyrocopter without proper training resulting in the inflight loss of control and subsequent crash.NTSB LAX90FA138Accident · 3 fatalField investigationFinal reportBeech A36 · Kneeland, CAThe pilot's improper use of IFR procedures by failing to maintain the minimum descent altitude for the segment of the approach that he was flying. The hilly/mountainous terrain was a related factor.NTSB FTW90FA091Accident · 1 fatalField investigationFinal reportLuscombe 8-A · Baytown, TXThe pilot's inadvertent stall of the airplane while maneuvering after a partial power loss during initial climb and a partially blocked exhaust system which had been inadequately maintained.NTSB FTW90DQA01Accident · 1 fatalFinal reportAir Command 532 · El Paso, TXFailure of the pilot to maintain aircraft control and rotor RPM. Factors related to the accident were: the pilot's lack of instruction and experience in rotorcraft.NTSB DEN90LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Ogallala, NEThe misjudged landing flare. A factor was the pilot's lack of experience.NTSB NYC90DFJ02Accident · 1 fatalFinal reportRobbins Breezy CG-1 · Horseheads, NYThe loss of aircraft control during high speed taxi for an unknown reason.NTSB LAX90LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Concord, CAThe pilot in command to properly judge the timing of the landing flare.NTSB ANC90LA045Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315B · Trading Bay, AKThe pilot's inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: snow covered terrain, adverse weather conditions, and spatial disorientation of the pilot, due to lack of visual cure during the landing.NTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.NTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…NTSB SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.NTSB MIA90FA101Accident · 1 fatalField investigationFinal reportLockheed L-1049F · Levittown, PRFire of an undetermined origin that resulted in a loss of power in two engines during a three engine ferry flight. Factors related to the accident were: failure of the pilot to obtain the required authorization for the three engine ferry flight, and his…NTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.NTSB CHI90FA108Accident · 1 fatalField investigationFinal reportBeech M35 · Romeo, MIA loss of control due to physical incapacitation (heart attack).NTSB ATL90LA092Accident · No injuriesLimited investigationFinal reportBeech B35 · Brunswick, GAThe pilot's failure to properly manage his fuel supply by switching to a tank with fuel prior to the loss of engine power. Collision with the tree(s) was a factor related to the accident.NTSB MKC90LA080Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mounds, ARThe pilot's improper compensation for wind conditions. Factors related to the accident were: the pilot's selection of the wrong runway and the resultant tailwind condition.NTSB MIA90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jackson, MSThe pilot's improper compensation for the cross-wind.NTSB LAX90LA137Accident · No injuriesLimited investigationFinal reportBell 47G · La Verne, CAThe helicopter's rotor system being allowed to underspeed as a result of improper use of flight controls by the dual student; improper supervision by the certified flight instructor; and delayed remedial action by the certified flight instructor which allowed…NTSB LAX90FA135Accident · 1 fatalField investigationFinal reportGardner Pitts S-1 · Eloy, AZThe pilot delayed the recovery from the inverted flat spin maneuver and misjudged his altitude.NTSB LAX90DVG04Accident · 1 fatalFinal reportGrumman G-164B · Esparto, CAThe pilot misjudged the airplane's clearance with the transmission wires.NTSB FTW90DPA01Accident · No injuriesFinal reportGrumman G-164B · Bonham, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN90LA086Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morgan, UTSeparation of the tow rope and the pilot's failure to establish an appropriate descent rate as he returned to land. Contributing to the accident were the tailwind and the unsuitable terrain for landing beyond the runway end.NTSB MKC90LA079Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Des Arc, ARFailure of the engine fuel pump.NTSB MIA90TL#03Accident · Minor injuriesClass 3Final reportEnstrom F-28A · Ft Pierce, FLNTSB LAX90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chino, CAFuel starvation due to the fuel tank outlets becoming unported as the aircraft maneuvered for landing. A factor was the pilot's preflight planning failed to insure that he had adequate fuel for the flight.NTSB FTW90LA090Accident · No injuriesLimited investigationFinal reportHughes H500C · Houston, TXThe total failure of the engine for undertemined reasons and the pilot misjudging the flare prior to touchdown.NTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.NTSB FTW90DPJ04Accident · 1 fatalFinal reportMooney M20F · Bethany, OKLoss of control in flight when the pilot stalled and spun the airplane inadvertently while turning to the base leg. A factor was lack of night flying time.NTSB CHI90IA106Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600F · West Lafayette, INAn undetected accumulation of ice on the horizontal stabilizer. Relating factors were the manufacturer's lack of information and aircraft manuals relative to the understanding of, and appropriate procedures to prevent the loss of control.NTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.NTSB ATL90LA091Accident · No injuriesLimited investigationFinal reportPZL 80 · Wilmington, NCPilot's failure to properly adjust the throttle friction which resulted in the disconnection of the entire assembly.NTSB SEA90LA060Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Hillsboro, ORThe pilot's failure to refuel resulting in fuel exhaustion.NTSB SEA90FA071Accident · 1 fatalField investigationFinal reportNorth American Navion H · Enumclaw, WAPilot's inadequate preflight planning, and inadvertent flight into IMC conditions. Factors in the accident were the low ceiling and visibility weather conditions, the mountainous/hill terrain, the pilot's lack of instrument qualification and his lack of…NTSB MKC90LA078Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Belleville, KSThe pilot's inadequate remedial action in response to the loss of power in the right engine, which resulted in his failure to attain the proper touchdown point for landing.NTSB LAX90TL#01Accident · No injuriesClass 3Final reportGates Learjet 35 · Carlsbad, CANTSB LAX90LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Cottonwood, AZThe failure to the pilot to maintain control of the aircraft. Contributing to the accident was the decision of the pilot to attempt a landing in a cross wind condition well beyond the capability of the aircraft.