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 LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.NTSB FTW92GA160Accident · No injuriesFinal reportMcdonnell Douglas 369E · Yukon, OKThe dual student's failure to maintain adequate main rotor RPM and failure to level the helicopter at touchdown. Factors were the manufacturer's training pilot's inadequate supervision and the dual student performing the maneuver.NTSB FTW92GA157Accident · 1 fatalFinal reportHughes OH-6A · Sunland Park, NMThe pilot's failure to see and avoid the wires.NTSB FTW92DQA02Accident · Serious injuriesFinal reportFantasy Sky Promotions AX-7 · Rio Rancho, NMThe pilot's improper inspection of the balloon following removal of two of the fuel tanks which resulted in vented fuel due to a fuel line being left loose and a fuel valve locked open.NTSB DEN92LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper use of brakes. Factors were: poorly planned approach and excessive landing speed.NTSB CHI92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Breezy Point, MNThe partial failure of the tail wheel assembly due to a fatigue fracture of an internal spring.NTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.NTSB CHI92LA175Accident · 1 fatalLimited investigationFinal reportChampion 7GCAA · Brainerd, MNAn excessive pull up and failure to maintain an airspeed above stalling speed by the pilot in command.NTSB CHI92LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Ladysmith, WIFailure of the pilot to attain a proper touchdown point and the attempted abort of the precautionary landing attempt.NTSB CHI92DTG02Accident · Minor injuriesFinal reportCallair A9B · Bisbee, NDThe loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.NTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.NTSB NYC92LA116Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Greenville, METhe pilots decision to initiate a step turn into the wind. Factors related to the accident were the crosswind and gusts.NTSB LAX92LA243Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZThe pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.NTSB CHI92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Liberty, MOThe pilot-in-commands failure to maintain aircraft control. Related factors are the pilot's lack of total experience and improper recovery from a bounced landing.NTSB CHI92FA170Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Sheboygan Falls, WIThe copilot's premature liftoff and the captain's inadequate remedial action resulting in loss of aircraft control at low altitude.NTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.NTSB MIA92LA136Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Live Oak, FLImproper planning/decision by the pilot, and his improper use of the mixture control, which resulted in his failure to attain sufficient altitude to clear trees near the departure end of the runway. The proximity of trees was a related factor.NTSB LAX92TL#09Accident · No injuriesClass 3Final reportCessna 421C · Window Rock, AZNTSB LAX92FA242Accident · 3 fatalField investigationFinal reportCessna 172I · Chino Hills, CAThe pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.NTSB DEN92LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Englewood, COAirplane climb capability exceeded and an inadvertent pilot induced stall. Factors were: weight and balance exceeded, high density altitude, and improper use of the mixture control.NTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.NTSB CHI92FA169Accident · 1 fatalField investigationFinal reportMooney M20J · Bloomington, ILThe pilot's failure to maintain aircraft control during the turn from base leg to final approach.NTSB SEA92LA124Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Klamath Falls, ORThe pilot's poor inflight planning/decision. Factors to the accident were: clearance was not maintained and inadequate remedial action.NTSB NYC92LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Woodbine, MDThe student pilot's failure to maintain directional control of the glider during takeoff, which resulted in a ground loop. Factors related to the accident were the student's lack of total flight experience, the instructor's lack of flight experience in this…NTSB NYC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Denton, MDThe failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.NTSB NYC92LA106Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2 · Danbury, CTImproper recovery from a bounced landing by the pilot which resulted in a propeller strike which made further flight not possible.NTSB LAX92TL#08Accident · No injuriesClass 3Final reportPiper PA36-300 · Madera, CANTSB FTW92IA158Incident · No injuriesIncident investigationFinal reportPiper PA-31T · Addison, TXThe failure of the pilot-in-command of the PA-38, N2603B, to follow ATC instructions.NTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.NTSB CHI92LA166Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOThe flight instructor's delay in initiating a go-around and improper recovery from the student's bounced landing. Factor(s) which contributed to the accident was the student pilot overshooting the approach.NTSB ATL92LA120Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG 300 · Arabi, GAThe pilot's inadequate visual lookout when he failed to see and avoid obstacles. Factors were the loss of thermal lift and the pilot's diverted attention.NTSB ANC92LA090Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-500D · Polk Inlet, AKThe pilot's failure to follow proper procedure and the company's inadequate procedures and directives. A factor was the uneven terrain.NTSB ANC92LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKInadequate visual look out by the pilot of both aircraft. Contributing to the accident were the pilot's diverted attention, the other moving aircraft/object (c 172), and the excessive taxi speed of the c 172.NTSB ANC92LA088Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elephant Lake, AKThe dual student's inadequate compensation for wind conditions and the instructor's inadequate supervision. A factor was the tailwind.NTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.NTSB SEA92LA122Accident · No injuriesLimited investigationFinal reportNorth American Navion · Spokane, WAThe partial failure of the nose gear trunnion. Factors include the pilot's decision to land with the gear in the up position.NTSB NYC92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Buffalo, NYThe pilot's failure to maintain airspeed during a go around, which resulted in an inadvertent stall and in flight collision with terrain. Contributing to the accident was the pilot delayed the go around and lack of recent flight expereince.NTSB NYC92LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Dexter, MEA failure of the top torque link bolt on the nose landing gear which resulted in a landing with a flat strut and misaligned wheel.NTSB NYC92FA103Accident · 1 fatalField investigationFinal reportCessna 180G · Reynoldsville, PAThe pilot's failure to refuel resulting in fuel exhaustion and subsequent forced landing in trees.NTSB MIA92LA135Accident · Minor injuriesLimited investigationFinal reportHiller UH12C · Punta Gorda, FLThe pilot in command's failure to monitor fuel consumption and flight time resulting in exhaustion of fuel and engine failure. Contributing to the accident was the pilot in command's improper autorotation following engine failure which resulted in a hard…NTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.NTSB MIA92GA134Accident · 1 fatalFinal reportCessna U206-F · Live Oak, FLImproper maintenance of the fuel system by the pilot/mechanic resulting in an engine failure on takeoff over terrain unsuitable for a forced landing. Contributing to the accident was the pilot's improper in-flight decision to turn back to the runway, and…NTSB LAX92LA239Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chino, CAThe loss of engine power for undetermined reasons. The pilot's misjuding the flare was a factor.NTSB LAX92FA241Accident · 3 fatalField investigationFinal reportCessna 172P · Big Sur, CAPilot incapacition.NTSB CHI92LA167Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wyatt, MOAn improper decision during flight when the pilot in command overflew two suitable landing areas after a partial power loss in one engine. The mechanical deficiencies in the engines were factors in the engine.NTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.NTSB NYC92LA102Accident · No injuriesLimited investigationFinal reportGrumman 164A · Bridgeton, NJThe pilot's improper application of takeoff power which resulted in a lengthened takeoff roll, and his subsequent steep turn to avoid an obstacle causing the airplane to stall at a low altitude.NTSB MIA92LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Opa Locka, FLThe pilot's inadequate compensation for wind condition and failure to maintain runway alignment during the landing roll. A contributing factor was a shifting crosswind.NTSB FTW92LA154Accident · No injuriesLimited investigationFinal reportBeech 76 · Sherman, TXThe instructor pilot's delayed remedial action, improper configuration, and inadvertent stall.