NTSB investigations, 2002
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CHI02LA209Accident · No injuriesLimited investigationFinal reportBeech S35 · Minneapolis, MNThe proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.NTSB ANC02LA083Accident · No injuriesLimited investigationFinal reportCessna 206 · Kodiak, AKThe pilot's inadequate compensation for wind conditions during the takeoff run, which resulted in a loss of control and subsequent nose over. A factor associated with the accident was wind gusts.NTSB SEA02LA136Accident · No injuriesLimited investigationFinal reportStearman C3-R · Arlington, WAThe pilot's inadequate remedial action when responding to the swerve/veer of the tailwheel equipped aircraft, leading to a failure to maintain directional control during the landing roll. Factors include the pilot’s lack of experience in the make and model…NTSB MIA02LA138Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Trenton, GAThe failure of the pilot to clear the engine during a prolonged approach at idle power resulting in the engine hesitating during application of power to arrest the descent for landing touchdown resulting in a hard landing and separation of the left main…NTSB LAX02LA236Accident · No injuriesLimited investigationFinal reportCessna TR182 · Yuma, AZthe pilot's failure to properly verify that the landing gear was in the down and locked position.NTSB LAX02FA234Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kneeland, CAThe pilot's failure to maintain clearance with the trees while executing an instrument approach. Contributing factors were the clouds and obscuration weather conditions.NTSB DEN02LA095Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Lehi, UTthe pilot's inadequate in-flight planning resulting in the glider impacting terrain short of the runway, and the pilot's subsequent abrupt handling of the glider when it became airborne again, which resulted in a hard second landing. A contributing factor was…NTSB CHI02LA225Accident · No injuriesLimited investigationFinal reportCessna 140 · Cook, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC02LA081Accident · No injuriesLimited investigationFinal reportMBB BO-105S · Deadhorse, AKThe pilot's failure to correct a settling-with-power condition during a helicopter landing flare/touchdown, resulting in a hard landing and roll over.NTSB SEA02LA135Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Medford, ORPower loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.NTSB NYC02LA144Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Zelienople, PAThe pilot failure to follow the published aborted landing procedures, with the retraction of the flaps to 10 degrees prior to reaching a safe altitude and airspeed, which resulted in an uncontrolled descent.NTSB CHI02LA207Accident · No injuriesLimited investigationFinal reportCessna C180A · Ogallala, NEThe pilot's failure to maintain directional control of the aircraft. The open window diverting the pilot's attention was a contributing factor.NTSB CHI02LA206Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Pratt, KSThe pilot's failure to maintain terrain clearance. A factor was low altitude flight.NTSB NYC02LA146Accident · No injuriesLimited investigationFinal reportSaab-Scania 340A · Charleston, WVThe vehicle driver's failure to maintain clearance of the airplane.NTSB FTW02WA213Accident · 6 fatalForeign investigationCessna 206 · Guachochi, MexicoNTSB FTW02LA219Accident · No injuriesLimited investigationFinal reportSchempp-Hirth K.G. Nimbus-2C · Briggs, TXthe pilot's failure to maintain clearance with the high grass during the landing roll, which resulted in a ground loop.NTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.NTSB CHI02FA200Accident · No injuriesField investigationFinal reportPiper PA-20 · Oshkosh, WIInadequate visual lookout by both the accident pilot and the pilot of the other airplane. An additional cause is the arrival procedure used which resulted in a congested traffic pattern and the subsequent inadequate visual separation of the airplanes. Factors…NTSB CHI02FA199Accident · 2 fatalField investigationFinal reportBeech E-90 · Bloomington, ILThe cause of the accident is undetermined.NTSB CHI02CA214Accident · No injuriesData collectionFinal reportCessna 182A · Laretto, MNThe pilot's improper flare.NTSB SEA02LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Pe Ell, WAThe fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.NTSB LAX02LA232Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Knights Landing, CAThe pilot's inadequate visual lookout, resulting in an in-flight collision with wires.NTSB IAD02LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Port Clinton, OHThe pilot's improper flare, and his failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB IAD02FA074Accident · 1 fatalField investigationFinal reportWehrlen Glassair II RG · Jackson, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with terrain.NTSB CHI02LA208Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Askov, MNDirectional control not obtained/maintained during the aborted takeoff.NTSB CHI02LA195Accident · No injuriesLimited investigationFinal reportMeyers OTW-145 · Waupun, WIA loss of engine power due to fuel exhaustion as a result of the fuel pump failure. Contributing to the accident was the wheat field.NTSB CHI02FA234Accident · 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 CHI02CA201Accident · Minor injuriesData collectionFinal reportSchweizer 1-26B · New Douglas, ILThe probable cause of this accident was a failure to maintain the proper glide path and sufficient obstacle clearance while on final approach.NTSB ATL02LA144Accident · 5 fatalLimited investigationFinal reportPiper PA-32RT-300 · Atlantic Ocean, BahamasThe pilot continued VFR flight into IMC and thunderstorm conditions which resulted in spatial disorientation and subsequent loss of control of the airplane.NTSB NYC02LA143Accident · No injuriesLimited investigationFinal reportBeech 58 · Provincetown, MAThe pilot's failure to initiate a timely go-around, which resulted in his landing the airplane long and fast. Factors included low ceilings and the airplane's initial misalignment with the runway.NTSB FTW02LA212Accident · No injuriesLimited investigationFinal reportCessna 190 · Albuquerque, NMThe pilot's failure to maintain aircraft control. A contributing factor was the crosswind.NTSB DEN02LA077Accident · No injuriesLimited investigationFinal reportCessna 150L · Hurricane, UTpilot's failure to maintain directional control during landing roll, resulting in an inadvertent ground loop.NTSB DEN02GA074Accident · 2 fatalFinal reportConsolidated-Vultee P4Y-2 · Estes Park, COthe inflight failure of the left wing due to fatigue cracking in the left wing's forward spar and wing skin. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.NTSB CHI02LA205Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · El Dorado Sprgs, MOThe failure by the flight crew to abort the takeoff, as well as a failure by the flight instructor to properly monitor takeoff performance. Contributing factors to the accident were the flight crew's failure to calculate required takeoff distance, considering…NTSB CHI02CA203Accident · Minor injuriesData collectionFinal reportBilgri Sonerai II Lts · Juneau, WIThe pilot's failure to maintain sufficient airspeed while maneuvering to return to the airport. A reduction in handling quality and the distraction due to the open canopy were contributing factors.NTSB CHI02CA202Accident · Minor injuriesData collectionFinal reportEckstein RV-6A · Mattawan, MIFailure by the pilot in command to attain a proper touchdown point considering the available runway length. The rough, uneven runway surface and the soft area at the far end of the runway were contributing factors.NTSB NYC02FA142Accident · 2 fatalField investigationFinal reportBeech C24R · Grindstone, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.NTSB LAX02LA230Accident · Serious injuriesLimited investigationFinal reportViolet Dragonfly · Tucson, AZThe pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.NTSB FTW02LA216Accident · No injuriesLimited investigationFinal reportBell TH-13T · New Iberia, LAThe loss of engine power for undetermined reasons. High vegetation was a factor.NTSB FTW02FA211Accident · 1 fatalField investigationFinal reportNorth American AT-6A · Albany, TXThe pilot's failure to maintain aircraft control.NTSB DEN02LA079Accident · No injuriesLimited investigationFinal reportCessna 150F · Grants, NMthe pilot's inadequate preflight preparation, and his failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the high density altitude conditions, the terrain barrier (berm).NTSB CHI02FA197Accident · 1 fatalField investigationFinal reportPiper PA-60 · Columbus, INThe pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.NTSB CHI02FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lee's Summit, MOThe inadequate preflight planning/preparation, the flight into instrument meteorological conditions, and lack of instrument certification by the pilot. Contributing factors were fog/clouds and the pilot's nondisclosure of his physical condition to the Federal…NTSB CHI02CA211Accident · No injuriesData collectionFinal reportCessna 172N · Spearfish, SDThe probable cause of this accident was the pilot's failure to maintain directional control of the airplane during the takeoff roll. Differences in control forces and aircraft handling due to initiating the takeoff without fully retracting the flaps is a…NTSB ANC02LA080Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cordova, AKThe pilot's selection of an unsuitable runway for takeoff, which precipitated an in-flight loss of control and subsequent collision with terrain.NTSB NYC02LA141Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Dayton, OHThe inadequate visual lookout by the pilot of the Kitfox. Factors related to the accident were the non-radio equipped Waco, and the hazy visual conditions.NTSB NYC02LA140Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Bardstown, KYThe pilot's inadequate preflight inspection, which resulted in fuel contamination and subsequent loss of engine power. A factor in this accident was that the wing tank fuel drains were wire closed and could not be used.NTSB MIA02LA136Accident · No injuriesLimited investigationFinal reportYakovlev Yak 52 · Parrish, FLThe in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.NTSB MIA02LA135Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cochran, GAA loss of power while conducting aerial application to cotton crops due to failure of a magneto housing, and the resultant emergency descent and landing to an unsuitable field, causing the collision with a tree.NTSB MIA02GA137Accident · 3 fatalFinal reportCessna 172S · Tyner, NCThe loss of power for undetermined reasons, and the pilot's failure to maintain airspeed.