NTSB investigations, 2002
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 WHERE year(c.\"eventDate\") = 2002 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 WHERE year(c."eventDate") = 2002 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 SEA02FA097Accident · No injuriesField investigationFinal reportLewis Nieuport 11 · Independence, ORThe partial loss of engine power in maneuvering flight due to the rotation of the ignition distributor as a result of a failure to tighten the distributor positioning clamp after the last engine timing adjustment. Factors include an inadequate maintenance…NTSB LAX02LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbia, CAThe pilot encountered a crosswind gust during the landing roll, resulting in a ground loop and nose over.NTSB LAX02LA190Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fallon, NVthe pilot's failure to attain an adequate takeoff airspeed, which resulted in a stall/mush. The high gross weight and density altitude were contributing factors.NTSB IAD02LA058Accident · No injuriesLimited investigationFinal reportNorth American T6G · Salem, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop.NTSB FTW02LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Crawford, TXThe loss of engine power as a result of the pilot's exceedence of the engine's temperature limits, resulting in the melting of blades on the first and second stage turbine wheels. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA176Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Dover, ARThe pilot's failure to maintain clearance with trees during the approach. A contributing factor was dark night light conditions.NTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.NTSB CHI02LA160Accident · Minor injuriesLimited investigationFinal reportNavion Navion A · Forest Lake, MNThe pilot not performing an aborted takeoff. The soft turf runway and power lines were contributing factors.NTSB CHI02FA233Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.NTSB NYC02LA099Accident · No injuriesLimited investigationFinal reportBoucher Revolution Mini 500 · Sterling, MAA misalignment of the rotor system drive belt, which resulted in belt chaffing, its subsequent separation, and a resultant loss of power to the rotor system. Also causal was the relatively low altitude and airspeed at which the separation occurred, which…NTSB LAX02LA192Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Goldfield, NVThe pilot's failure to maintain control of the airplane during a high density altitude takeoff. Contributing factors were the pilot's lack of experience in the type of operation and a wind gust.NTSB LAX02LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Henderson, NVThe pilot's misjudged landing flare during an autorotation, which resulted in a hard landing. The pilot's failure to follow the listed emergency procedures in the rotorcraft flight manual and the partial failure of the rotor system's drive belts were factors.NTSB LAX02LA187Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Placerville, CAA loss of engine power due to the pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB LAX02FA191Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Rio Rico, AZa loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…NTSB LAX02FA188Accident · 2 fatalField investigationFinal reportFisher Celebrity · Chandler, AZfailure of the wing spars and the in-flight separation of the aircraft wing due to the builder's inadequate manufacture of this experimental aircraft. Also causal was the current owner/pilot's continued flight with known mechanical discrepancies.NTSB FTW02LA177Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Nederland, COthe pilot's inadvertent in-flight encounter with severe turbulence, which resulted in main rotor-tailboom contact and the separation of the tailrotor drive shaft.NTSB FTW02LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Provo, UTthe total loss of engine power for reasons undetermined.NTSB CHI02LA157Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Fishers, INThe pilot not performing a go-around prior to exceeding the proper touchdown point and the pilot not maintaining altitude/clearance from the trees. Factors to the accident were the pilot's inadequate preflight planning and the trees.NTSB CHI02LA155Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Alexandria, INThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was the low altitude.NTSB ANC02TA045Accident · No injuriesFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate evaluation of the weather conditions during landing at a remote lake, resulting in a downwind landing. Factors contributing to the accident were the presence of a tailwind, and an icy lake surface.NTSB ANC02LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the left wing striking the ground. A factor contributing to the accident was the grass-covered runway surface.NTSB ANC02LA044Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's failure to compensate for a crosswind while taxiing, resulting in the right wing striking the water. A contributing factor in the accident was the presence of a crosswind.NTSB MIA02LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Meridian, MSinadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.NTSB LAX02LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Henderson, NVThe student pilot's inadequate recovery from a bounced landing and the instructor's inadequate supervision.NTSB LAX02LA185Accident · No injuriesLimited investigationFinal reportCessna A185F · Angwin, CAThe pilot's inadequate compensation for the wind conditions resulted in a loss of directional control and a ground loop/swerve.NTSB LAX02FA200Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · Santa Paula, CAthe pilot's attempted VFR flight into instrument conditions and failure to maintain clearance with the terrain.NTSB FTW02LA174Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXthe partial loss of engine power due to the mixture control rod separating from the carburetor. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.NTSB DEN02FA050Accident · 1 fatalField investigationFinal reportBeech M35 · Briggsdale, COcontrolled descent into terrain for reasons undetermined.NTSB CHI02LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Harvard, ILThe pilot's failure to verify the extension of the landing gear. Factors were the alternator failure, and the main landing gear down locks not engaged.NTSB ANC02LA043Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Galena, AKThe pilot's selection of unsuitable terrain for landing which precipitated a grass fire. Factors contributing to the accident were the manufacturer's inadequate design of the helicopter's exhaust system, placing it low to the ground, and terrain conditions…NTSB WAS02WA045Accident · 2 fatalForeign investigationSchweizer 269C · Paderborn-Lipsd, GermanyNTSB MIA02LA107Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Manteo, NCa total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.NTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.NTSB LAX02LA184Accident · No injuriesLimited investigationFinal reportCessna 172S · Monterey, CAThe pilot was unfamiliar with the airplane's systems and failed to set the elevator trim in accordance with the published checklist.NTSB LAX02LA183Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe dual student's improper autorotation and the flight instructor's inadequate supervision.NTSB IAD02IA057Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · Cinncinnati, OHThe partial loss of flight displays for undetermined reasons.NTSB CHI02LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Minneapolis, MNThe pilot's failure to maintain control of the aircraft during an aborted landing.NTSB CHI02LA153Accident · No injuriesLimited investigationFinal reportCessna 150C · Minneapolis, MNThe pilot's improper flare resulting in the hard landing.NTSB ATL02WA120Accident · No injuriesForeign investigationCessna P210N · Treasure Cay, BahamasNTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.NTSB WAS02WA046Accident · 4 fatalForeign investigationBell 206B (II) · Dhoyntji, AustraliaNTSB FTW02LA172Accident · No injuriesLimited investigationFinal reportBeech BE-100-A100 · Little Rock, ARThe malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.NTSB CHI02LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Langdon, NDThe pilot did not maintain directional control while taxiing. A contributing factor was the wind gust condition present at the time of the accident.NTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.NTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.NTSB MIA02FA104Accident · 1 fatalField investigationFinal reportCessna 172S · Lutz, FLThe suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…NTSB LAX02LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Mountain Ranch, CAthe pilot's inadequate preflight planning/preparation and his in-flight planning/decision resulting in fuel exhaustion and loss of engine power.NTSB CHI02IA151Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Wichita, KSThe flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…NTSB CHI02FA148Accident · No injuriesField investigationFinal reportDouglas DC-9-31 · Minneapolis, MNThe failure of the right main landing gear due to fatigue.