NTSB investigations, 2001
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\") = 2001 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") = 2001 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 ANC01LA127Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Chickaloon, AKThe pilot's delay in aborting the takeoff. Factors in the accident were the presence of trees at the end of the departure path, and the pilot's improper use of the carburetor heat control.NTSB SEA01LA160Accident · Serious injuriesLimited investigationFinal reportShank Kitfox Model II · Battle Ground, WAThe pilot's failure to maintain adequate airspeed during climbout.NTSB SEA01IA161Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Portland, ORImproper tension of the right control yoke chain; a worn right aileron spring tab hinge bearing; improper tension of the left aileron spring tab aft spring and worn contact stud; improper tension of the right aileron spring tab and a worn contact stud; a worn…NTSB LAX01LA292Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Mesa, AZThe pilot's improper autorotation in that he failed to attain the proper descent rate resulting in a hard landing and subsequent airframe damage. A factor was the high temperature.NTSB LAX01GA291Accident · 2 fatalFinal reportGrumman TS-2A · Hopland, CAthe failure of both pilots to maintain an adequate visual lookout. The failure of the pilot in Tanker 87 to comply with suggested procedures regarding positive radio contact and orbit entry was a factor.NTSB FTW01LA193Accident · No injuriesLimited investigationFinal reportGrumman G164B · Rayville, LAthe partial failure of the magneto drive coupling while maneuvering, which resulted in a loss of engine power and a forced landing. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB DEN01LA153Accident · Minor injuriesLimited investigationFinal reportBradley Rans S-7 · Fruita, COloss of engine power due to both piston rings failing, and the subsequent inadvertent stall/spin during the attempted forced landing. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI01LA302Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · West Chicago, ILthe checklist not followed and the directional control not maintained by the pilot. A contributing factor was the left propeller’s start locks being engaged.NTSB CHI01LA296Accident · No injuriesLimited investigationFinal reportDassault/SUD Fan Jet Falcon · Detroit, MIThe wheels up landing performed by the flightcrew during the emergency landing and improper aircraft preflight by the pilot in command. Factors were the unsecured cargo door, the cemetery fence, and the lack of crew coordination during the flight.NTSB CHI01LA295Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Romeo, MIthe reason for the loss of engine power is undetermined.NTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.NTSB SEA01LA158Accident · 1 fatalLimited investigationFinal reportMatey Hawker Hurricane · Buckley, WAA loss of power for undetermined reasons, and the pilot's inflight decision to attempt a 180 degree turn back to the runway from low altitude and his failure to maintain sufficient flying airspeed during the turn. A contributing factor was drug impairment of…NTSB NYC01FA217Accident · 2 fatalField investigationFinal reportCessna 172SP · Matawan, NJThe pilot's failure to maintain runway alignment during the initial climb. Factors were the pilot's failure to perform a go-around, the pilot's lack of flight experience in nighttime conditions, the nighttime conditions, and a tailwind.NTSB ATL01LA097Accident · 1 fatalLimited investigationFinal reportTroy A. Woodland Sky Raider II · NewSmyrna Beach, FLThe pilot's failure to maintain airspeed while performing an emergency maneuver, resulting in a stall and an uncontrolled descent, and the subsequent collision with terrain. A factors was, the loss of engine power for undetermined reasons.NTSB ATL01LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Valdosta, GAThe flight instructor's improper flare of the airplane, which resulted in a hard landing. Factors were the dual student's failure to relinquish control of the airplane and the dual student's interference on the flight controls.NTSB NYC01LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Danbury, CTAn inoperative airspeed indicator and the pilot's improper recovery from the bounced landing.NTSB LAX01FA290Accident · No injuriesField investigationFinal reportPiper PA-32-301T · Fullerton, CAThe engine lost power for unknown reasons.NTSB FTW01LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Miami, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI01LA293Accident · No injuriesLimited investigationFinal reportHughes 269B · Pontiac, MIthe checklist not compiled with by the operator and not verified by the operator’s pilot and the operator's flight instructor. An additional cause was the improper autorotation by the pilot in command. The out of calibration engine idle speed was a…NTSB ATL01LA098Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Eagleville, TNThe loss of thermals during the glider flight that resulted in the collision with high vegetation while maneuvering for an emergency landing. A factor was high vegetation.NTSB ATL01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homerville, GAThe improper replacement of an accessory drive component with an unapproved part by maintenance personnel, which resulted in a fatigue fracture of the component and loss of engine power. The airplane subsequently collided with power lines and trees during an…NTSB SEA01LA157Accident · No injuriesLimited investigationFinal reportSuper Quickie 2 · Bonney Lake, WAImproper carburetor adjustment resulting in a total loss of engine power while in a descent configuration. Factors include an excessively lean mixture setting and unsuitable terrain for landing.NTSB MIA01WA221Accident · No injuriesForeign investigationCessna U206G · Valencia, VenezuelaNTSB MIA01RA225Accident · 9 fatalForeign investigationCessna 402B · Marsh Harbour, BahamasNTSB LAX01LA293Accident · No injuriesLimited investigationFinal reportChampion 7FC · Reno, NVThe failure of the pilot to maintain directional control during the landing roll.NTSB LAX01LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Camarillo, CAThe improper fabrication/reassembly and inspection of the engine throttle control linkage during aircraft restoration by the operator, and the failure of the operator's inspection personnel to detect the error during subsequent annual inspections.NTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.NTSB IAD01LA100Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Amherst, NHSuicide, when the pilot intentionally crashed his airplane into his house.NTSB FTW01LA199Accident · No injuriesLimited investigationFinal reportJohn Greenlee X-Aircamper · Healdton, OKThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat during the approach to land. Contributing factors were weather conditions conducive to carburetor icing conditions and the lack of suitable terrain for…NTSB DEN01FA152Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Raton, NMa nonmechanical total loss of engine power for undetermined reasons while performing an aerobatic maneuver, and an inadvertent stall. A contributing factor was the insuffieient altitude to effect a safe recovery.NTSB CHI01FA292Accident · Minor injuriesField investigationFinal reportBoeing 737-3G7 · Kansas City, MOThe second in command failed to maintain proper runway alignment, directional control, and landed long. The pilot in command failed to execute a go-around and failed to provide adequate supervision. Additional factors included the thunderstorm, the dark…NTSB CHI01FA291Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Crestline, KSThe airplane's departure from level flight and subsequent impact with the terrain as a result of a maneuver initiated by the pilot, and the pilot's failure to maintain clearance from the terrain. The reason for the pilot's actions were not determined.NTSB ATL01LA102Accident · No injuriesLimited investigationFinal reportBeech 55 · Jacksonville, FLThe failure of the left landing gear extention rod for undetermined reasons that resulted in a landing with the gear retracted.NTSB NYC01FA215Accident · 1 fatalField investigationFinal reportBeech BE-200 · Piqua, OHThe pilot's improper decision to attempt a visual landing under instrument meteorological conditions and his failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with trees. A factor in this accident was the ground fog.NTSB NYC01FA214Accident · 2 fatalField investigationFinal reportLearjet 25 · Ithaca, NYThe pilot's failure to maintain a proper climb rate while taking off at night, which was a result of spatial disorientation. Factors in the accident were the low visibility and cloud conditions, and the dark night.NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB FTW01LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ardmore, OKthe student pilot's failure to maintain directional control during takeoff roll.NTSB FTW01LA195Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Cameron, LAfuel contamination due to the combination of DIEGME, water, and bacterial growth, which resulted in formation of an apple-jelly type material that blocked the fuel nozzle screen and led to a loss of engine power.NTSB DCA01WA062Incident · Minor injuriesForeign investigationAirbus Industrie A330-200 · Terceira-Azores, PortugalNTSB NYC01LA216Accident · No injuriesLimited investigationFinal reportCessna 182R · Elizabethtown, KYThe pilot's improper decision to fly the airplane with a known deficiency, and his inflight decision to land with a quartering tailwind. A factor was the wing maintenance officer's concurrence to fly the airplane with the known deficiency.NTSB FTW01TA194Accident · Minor injuriesFinal reportPiper PA-18-150 · Van Horn, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to the accident was the high density altitude.NTSB FTW01LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-46-310P · Bulverde, TXthe pilot's failure to obtain airspeed after rotation, which resulted in a stall/mush. Contributing factors were the tailwind condition, high density altitude, and upsloping runway.NTSB FTW01LA190Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Odom, ARthe pilot's failure to follow the proper procedures for hand-propping an airplane.NTSB DEN01FA151Accident · 2 fatalField investigationFinal reportAviat A-1 · Montrose, COthe pilot's intentional abrupt maneuver immediately after takeoff and the subsequent loss of aircraft control. Contributing factors were high density altitude weather conditions, and the airplane improper weight and balance.NTSB CHI01FA290Accident · 1 fatalField investigationFinal reportNavion L-17B · Newaygo, MIThe pilot inadvertently positioning the fuel selector in an intermediate position, resulting in a loss of engine power. An additional cause was the pilot's failure to verify the fuel selector position during the engine restart attempt. Factors to the accident…NTSB ANC01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was trees.NTSB SEA01LA156Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Twin Falls, IDNose over during the landing roll for undetermined reasons.NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…NTSB CHI01LA294Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Alice, NDThe pilot's unsuccessful recovery from an intentional aerobatic stall/spin maneuver. Contributing to the accident were the pilot's impairment (alcohol), and his psychological condition.