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 SEA89LA130Accident · Serious injuriesLimited investigationFinal reportCushing C2 · John Day, ORThe pilot improperly changed the design of the airplane by elongating holes at the wing attachment. The change was not inspected by a qualified individual. As a result of the change, the wing separated at the spar.NTSB NYC89LA159Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Akron, NYImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: soft terrain in the emergency landing area.NTSB NYC89LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beverly, MACollision with trees during an aborted landing and attempted go-around with insufficient remaining runway.NTSB MKC89LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Crystal, MNAircraft control was not maintained by the pilot in command, due to an improper landing flare which resulted in several bounces. The landing gear failed in overload during the bounced landing.NTSB MKC89FA156Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Medicine Lodge, KSThe pilot misjudged clearance above a house (residence) that he was buzzing and allowed the aircraft to collide with the attached antenna.NTSB MIA89LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel. The soft terrain in the emergency landing area was considered to be a contributing factor.NTSB MIA89LA188Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Kissimmee, FLThe failure of the carburetor throttle cable because of an inadequate annual inspection conducted 4.6 flight hours and one month before the accident.NTSB LAX89LA234Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hollister, CAFlight instructor's failure to take corrective action in sufficient time to prevent the airplane from striking the ground.NTSB LAX89LA233Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Los Angeles, CAAn undertorqued oil line fitting, due to its improper installation by maintenance personnel, which resulted in a loose oil line fitting, an oil line leak, oil exhaustion, and subsequent failure of the engine.NTSB LAX89LA232Accident · No injuriesLimited investigationFinal reportRyan SCW-145 · Santa Paula, CATotal loss of engine power for undetermined reasons.NTSB FTW89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Blanco, TXInadequate in-flight planning/decisions by not identifying the wind direction along with the failure to maintain airspeed. Contributing to the accident was the tailwind, wires and trees.NTSB FTW89LA130Accident · No injuriesLimited investigationFinal reportStinson V77 · El Paso, TXPilot's failure to maintain directional control during landing roll in a high crosswind environment.NTSB DEN89FA162Accident · 2 fatalField investigationFinal reportCessna 150K · Louisville, COInadequate supervision by the instructor pilot (CFI) and flight in known adverse weather conditions. Factors related to the accident were: inadequate preflight planning/preparation by the CFI, his lack of experience in the type of operation, and the weather…NTSB DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.NTSB CHI89IA145Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the citabria.NTSB CHI89IA144Incident · No injuriesIncident investigationFinal reportDornier DO-228 · Chicago, ILPoor lookout by the crew of the Dornier and the baron.NTSB CHI89IA143Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILPoor lookout by the crew of the DC-9 and the Cessna pilot.NTSB BFO89LA056Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bealeton, VAWater in the fuel, which resulted in a momentary loss of power during an inverted low pass, and the pilot's failure to plan the maneuver to allow for appropriate remedial action.NTSB ATL89DLT04Accident · Minor injuriesFinal reportPitts S-1 · Butler, TNThe failure of the pilot to maintain clearance from the surface during an impromptu acrobatic maneuver.NTSB NYC89LA168Accident · No injuriesLimited investigationFinal reportMooney M20C · Stormville, NYFailure of the pilot to maintain airspeed which resulted in an inadvertent stall.NTSB MKC89LA155Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Wymore, NEThe pilot's failure to maintain airspeed and altitude during climbout. Contributing to the accident was the high density altitude.NTSB MIA89IA187Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Naples, FLLeft main gear collapsed due to poor maintenance.NTSB LAX89LA265Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58T · Susanville, CAThe pilot's inflight decision to enter a descent when he lost yaw control of the aircraft. Turbulent weather conditions and an abrupt touchdown were factors in the accident.NTSB LAX89LA237Accident · No injuriesLimited investigationFinal reportCessna 150K · Woodland, CAThe pilot's poor judgement in not assuring an adequate fuel supply was on board for the flight.NTSB FTW89DPJ08Accident · Serious injuriesFinal reportGrumman G-164 · Guymon, OKFailure of the upper right engine mount (firewall attach bolt) due to fatigue, and failure of the lower right mounting bolt for an unknown reason, which allowed overload failure of the two remaining mounting bolts and separation of the engine.NTSB DEN89LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenwood Spgs, COInadequate compensation for wind conditions by the dual student, resulting in a loss of control and a forced landing. The pilot-in-command, CFI, failed to adequately supervise the operation.NTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.NTSB DEN89LA160Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Holden, UTThe pilot's misjudgement of the effect of high density altitude on a heavily loaded aircraft.NTSB CHI89FA129Accident · 2 fatalField investigationFinal reportPiper PA-18 · Roscommon, MILoss of control in flight while maneuvering and the failure to perform remedial action by the PIC.NTSB ATL89LA176Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Holly Hill, SCPilot misjudged his landing approach path and crossed the runway threshold too high to safely complete the landing. He also flared the airplane at too high an altitude resulting in a stall to a hard touchdown on the nose wheel exceeding the structural…NTSB ATL89FA175Accident · 2 fatalField investigationFinal reportBeech A45 · Troy, ALThe pilot's improper use of the airplane flight controls during a aerobatic maneuver at low altitude due to his lack of aerobatic experience. A contributing factor was the pilot's overconfidence in his ability to perform the maneuver.NTSB ATL89DKJ06Accident · Serious injuriesFinal reportPiper PA-25-235 · Goodway, ALThe in-flight separation of the left wing which failed because of a corrosion induced fatigue fracture.NTSB ANC89LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKLoss of engine power for an unknown reason. A factor related to the accident was: rough terrain in the emergency landing area.NTSB SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.NTSB LAX89LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Venice, CAThe improper installation and inspection of the carburetor throttle linkage arm.NTSB DEN89LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Fort Benton, MTOverload failure of the left main landing gear attaching bolts for an unknown reason.NTSB DEN89LA159Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Tierra Amarilla, NMThe failure of the pilot to maintain rotor RPM during the premature lift-off which resulted in a forced landing. Contributing to the accident was the high density altitude conditions, and unsuitable terrain.NTSB DEN89LA158Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Bountiful, UTThe pilot failed to maintain adequate speed for the turning maneuver (to avoid an obstacle) and inadvertently allowed the aircraft to stall. Contributing factors were: improper uuse of the flaps, high density altitude, and a high obstruction.NTSB CHI89FA128Accident · 3 fatalField investigationFinal reportBeech 58 · Battle Creek, MIThe flight crew inadvertently shut down the left engine after the right engine lost power, and the copilot failed to maintain control of the aircraft while maneuvering the aircraft back toward the runway. Factors related to the accident were: improper…NTSB BFO89LA055Accident · Serious injuriesLimited investigationFinal reportHughes 500D · Williamson, WVPilot's failure to see and avoid the wire which crossed the end of the field in which he was taking off.NTSB MIA89LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hilliard, FLThe inadequate pre-flight examination by the pilot, after refueling, which failed to detect water in the fuel.NTSB MIA89IA186Incident · No injuriesIncident investigationFinal reportBell 206L-1 · Chiefland, FLEngine failure due to failure of the first stage turbine wheel disk.NTSB LAX89LA231Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Sacramento, CAThe partial blockage of the engine induction system which resulted from improper maintenance.NTSB LAX89LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Merced, CAThe pilot's inadequate preflight planning/preparation, resulting in fuel exhaustion.NTSB LAX89DUG05Accident · No injuriesFinal reportSalmon KR-2 · Chino, CAThe pilot's overcontrolling of the aircraft. A factor in the accident was that this was the pilot's first flight in the aircraft.NTSB ANC89LA117Accident · No injuriesLimited investigationFinal reportCessna 206 · Eureka, AKThe pilot failed to maintain control of the airplane during a hard landing a subsequent go-around attempt.NTSB ANC89LA116Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Killey River, AKThe pilot failed to assure sufficient alt was obtained to compensate for the downdrafts near the ridge line.NTSB ANC89LA115Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Queens Cannery, AKThe pilot misjudged his altitude and distance to the runway during the approach and failed to attain the proper touchdown point. The gusty crosswind and berm were contributing factors.NTSB MKC89DPG02Accident · 1 fatalFinal reportRockwell S-2R · Reyno, ARImproper in-flight planning/decision by the pilot which resulted in a tight maneuver at inadequate airspeed and a subsequent stall. A contributing factor was the presence of high obstructions (trees).NTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.