NTSB investigations, 2002
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 FTW02FA162Accident · 1 fatalField investigationFinal reportCirrus Design SR-20 · Angel Fire, NMThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB CHI02LA144Accident · No injuriesLimited investigationFinal reportMitsubishi MU2B-20 · Belleville, MIThe pilot's failure to verify the extension of the landing gear prior to landing, and his failure to perform the emergency landing gear extension procedure. The popped circuit breaker was a factor.NTSB ATL02LA108Accident · No injuriesLimited investigationFinal reportCessna T210N · Orlando, FLThe pilot's inadequate planning decision that resulted in fuel exhaustion and subsequent loss of engine power.NTSB WAS02WA044Accident · Minor injuriesForeign investigationCessna TU 206F · Swan River, CanadaNTSB SEA02LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Lewiston, IDThe pilot's failure to maintain directional control during the landing resulting in the aircraft departing the runway environment and the wing impacting the ground. Contributing factors were the dustdevil/whirlwind which the aircraft encountered and the ditch.NTSB NYC02LA103Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Roxbury, NYThe airplane encountering an unanticipated downdraft that exceeded the climb performance of the airplane.NTSB ATL02LA114Accident · No injuriesLimited investigationFinal reportBeech 23 · Greensboro, NCThe loss of engine power for undetermined reasons, A factor was the pilot's intentional ground loop during a forced landing.NTSB ANC02FA038Accident · 2 fatalField investigationFinal reportPiper PA-18 · Lime Village, AKThe pilot's inadequate evaluation of weather and his inability to maintain aircraft control. A contributing factor was high winds due to thunderstorm outflow activity.NTSB SEA02LA089Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Tumtum, WAThe pilot's improper flare.NTSB SEA02LA087Accident · Serious injuriesLimited investigationFinal reportHanson Rans S6ES · Spanaway, WAThe loss of engine power for undetermined reasons during the climb-out after takeoff. Factors include no suitable terrain upon which to attempt a forced landing, and trees and cars alongside of the residential street that the pilot attempted to land on.NTSB MIA02LA099Accident · Minor injuriesLimited investigationFinal reportPiper J-3F-65 · Eton, GAThe pilot's failure to maintain directional control during initial climb after takeoff, resulting in collision with a power pole. A factor in the accident was the flight's encounter with a downdraft condition during initial climb.NTSB LAX02LA177Accident · Minor injuriesLimited investigationFinal reportCessna 310N · Dayton, NVA loss of engine power due to fuel starvation as a result of the pilot's failure to use a checklist and position the fuel selectors to tanks containing fuel.NTSB LAX02LA176Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Aganasabotage to the helicopter's fuel system, which resulted in a loss of engine power and a forced landing.NTSB LAX02LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Willits, CAthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors in the accident were the pilot's failure to raise the flaps and the wind shear conditions.NTSB IAD02LA054Accident · Minor injuriesLimited investigationFinal reportMiller Barnet J4B-2 · Manville, NJThe pilot's improper flare prior to touchdown. A factor was the pilot's lack of experience in aircraft type, make, and model.NTSB FTW02LA163Accident · Minor injuriesLimited investigationFinal reportPiper J-5 · Greers Ferry, ARThe loss of engine power for undetermined reasons. A factor was the probability of carburetor ice.NTSB FTW02LA160Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Hinton, OKFuel exhaustion due to a fuel cap leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.NTSB DCA02RA038Accident · 206 fatalForeign investigationBoeing 747-200 · Makung Island, TaiwanNTSB CHI02LA143Accident · Minor injuriesLimited investigationFinal reportRose 75% Scale Fokker D8 · Derby, KSInadequate preflight planning and inadequate compensation for the wind conditions which resulted in a failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the trees which the airplane contacted…NTSB ATL02LA110Accident · Serious injuriesLimited investigationFinal reportKendall, Blair Rans S-12 · Lincolnton, GAThe loss of engine power due to the delamination of the propeller blade during takeoff, and the pilot's improper touchdown flare during the emergency landing resulted in a hard landing.NTSB ATL02FA107Accident · 1 fatalField investigationFinal reportBell 47G-4A · Yauco, PRThe pilot's failure to apply carburetor heat that resulted in a partial loss of engine power and the subsequent collision with an object during the forced landing. A factor was weather conditions favorable for the formation of carburetor ice.NTSB ANC02LA039Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of weather conditions, which precipitated an in-flight loss of control and subsequent collision with terrain. A factor contributing to the accident was the tailwind.NTSB MIA02FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Fort Lauderdale, FLThe excessive rate of descent by the pilot-in-command during the autorotative landing resulting in a hard landing, following a total loss of engine power caused by failure of the No. 4 bearing.NTSB LAX02LA174Accident · No injuriesLimited investigationFinal reportCessna 175 · Anaheim, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB LAX02LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Lake Thomas A., CAa partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…NTSB FTW02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jonesville, LAthe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun and an on ground encounter with terrain.NTSB FTW02LA161Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Aubrey, ARThe failure of a compressor turbine blade(s) for an undetermined reason.NTSB DEN02LA048Accident · No injuriesLimited investigationFinal reportHelio H-391B · Cheyenne, WYthe pilot's failure to maintain directional control.NTSB DEN02LA046Accident · No injuriesLimited investigationFinal reportBell 206B-III · Moab, UTThe pilot's failure to maintain rotor rpm during a forced landing. A contributing factor was fuel starvation.NTSB CHI02LA142Accident · No injuriesLimited investigationFinal reportBell 47G-4 · Muncie, INThe pilot did not maintain directional control during hover taxi. Inadequate compensation for the crosswind conditions, the light rain, and the light pole were factors in the accident.NTSB ATL02LA105Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Panacea, FLLoss of engine power due to fuel starvation resulting from fuel restriction through the fuel shutoff valve.NTSB ANC02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Noorvik, AKThe partial loss of engine power during the climb to cruise for an undetermined reason, which resulted in a forced landing in soft terrain. A factor associated in the accident was the lack of suitable terrain for the forced landing.NTSB SEA02FA085Accident · 2 fatalField investigationFinal reportRobinson R-22 Mariner · Merlin, ORClearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.NTSB CHI02LA141Accident · No injuriesLimited investigationFinal reportCessna A185E · Grand Marais, MNThe pilot displayed inadequate compensation for the wind conditions that existed at the time of the accident and directional control was not maintained. A factor associated with the accident was the crosswind weather condition.NTSB CHI02FA140Accident · 1 fatalField investigationFinal reportSchutte Ms. Ryan Special · Anderson, INThe pilot's failure to properly install the canard attach bolts prior to the flight and the resulting inflight separation of the canard.NTSB ATL02WA109Accident · 1 fatalForeign investigationCessna 210F · Grand Cayman, Cayman IslandsNTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.NTSB ATL02LA103Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Charleston, SCTotal loss of engine power due to oil system starvation. A factor was the transmission wire encountered during emergency descent.NTSB ATL02FA104Accident · 3 fatalField investigationFinal reportCessna 172C · Ball Ground, GAThe flight instructor's failure to maintain adequate obstacle clearance, which resulted in an inflight collision with trees.NTSB SEA02LA084Accident · No injuriesLimited investigationFinal reportPaxhia Murphy SR3500 · Seattle, WAThe failure of the left main gear leg AN-5 attach fitting bolt.NTSB NYC02WA102Accident · No injuriesForeign investigationSchweizer 300C · Weiz, AustriaNTSB NYC02IA100Incident · No injuriesIncident investigationFinal reportDornier 328-300 · Albany, NYRudder oscillations of an undetermined origin.NTSB MIA02LA097Accident · No injuriesLimited investigationFinal reportCessna 206H · Sarasota, FLThe pilot's failure to maintain compensation for surface wind conditions resulting in excessive taxi speed, a loss of control while taxiing, an excursion off the taxiway, collision with a concrete pad, and a nose over.NTSB MIA02FA098Accident · 1 fatalField investigationFinal reportGrob G120A · Mobile, AZThe failure of the pilot to maintain altitude clearance with the terrain.NTSB LAX02LA171Accident · No injuriesLimited investigationFinal reportCessna 206 · Mohave Valley, AZthe pilot's failure to maintain directional control.NTSB LAX02FA173Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Mammoth Lakes, CAThe pilot's poor decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were rising mountainous terrain, the high density altitude, and the exceeded weight and…NTSB FTW02LA159Accident · No injuriesLimited investigationFinal reportCessna 172N · Glen Rose, TXThe pilot's failure to set the ignition key to the both magnetos position, which resulted in a loss of engine power. Contributing factors were the failure of the left magneto, the lack of suitable terrain for the forced landing, and the dark night.NTSB DEN02LA045Accident · No injuriesLimited investigationFinal reportCessna 172K · Cedar City, UTthe pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.NTSB DCA02WA040Accident · No injuriesForeign investigationBoeing 757-200 · Gibraltar, Gibraltar