NTSB investigations, 2001
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\") = 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 IAD01LA098Accident · No injuriesLimited investigationFinal reportCessna 150M · Cincinnati, OHThe pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB DEN01LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Peyton, COThe pilot's improper go-around procedure and his failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's lack of total experience.NTSB DEN01LA146Accident · Serious injuriesLimited investigationFinal reportCommander 114-B · Snowmass Villag, COThe pilot's failure to maintain altitude/clearance from the rising terrain for undetermined reasons. Contributing factors include high density altitude conditions, and trees.NTSB LAX01FA277Accident · Minor injuriesField investigationFinal reportMD Helicopters 600N · Fountain Hills, AZthe manufacturer's pilot's failure to maintain yaw control and main rotor speed while recovering from an unusual attitude induced by the customer pilot's inadequate control inputs while maneuvering at low altitude. The manufacturer's pilot's inadequate…NTSB IAD01FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's failure to recover from a spin for undetermined reasons.NTSB CHI01LA289Accident · No injuriesLimited investigationFinal reportCessna 177 · South Haven, MIThe pilot not maintaining aircraft control during the landing. Factors to the accident were the pilot not performing a go-around and the ditch.NTSB NYC01LA210Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Brockport, NYThe pilot's delayed go-around during the landing attempt. Factors included the dark night conditions and the pilot's inadequate preflight decision to fly to an airport with inoperative surface lighting.NTSB NYC01IA211Incident · No injuriesIncident investigationFinal reportCessna 210L · Bluefield, WVImproper maintenance which resulted in the installation of an unserviceable piston assembly, and the subsequent catastrophic engine failure. Factors in this accident were the improper inspection by the piston supplier and the softening of the piston.NTSB LAX01TA278Accident · Serious injuriesFinal reportDouglas DC-3C · Alturas, CAThe inadvertent encounter with terrain induced turbulence. A factor was the high terrain.NTSB ANC01LA108Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's selection of a the wrong runway, which resulted in a tailwind for the takeoff attempt. Factors associated with the accident are a short takeoff area, a tailwind, and the pilot's inadequate evaluation of the weather conditions.NTSB ANC01FA106Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Kotzebue, AKThe pilot's failure to maintain adequate clearance from an obstruction (antenna tower), and his continued flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, and low visibility.NTSB SEA01LA154Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Chimacum, WAAn internal ground in the right magneto followed by an internal ground evidenced by arcing in the left ignition coil unit, which led to failure of both the right magneto and the left coil ignition system respectively during cruise. Contributing factors were a…NTSB MIA01LA215Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Savannah, GAThe delay of the pilot to perform a go-around following a bounced landing and porpoise, and failure of the pilot to maintain directional control resulting in the airplane departing the runway and colliding with a berm.NTSB LAX01FA274Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Boulder City, NVthe pilot's failure to maintain an adequate terrain and obstruction clearance altitude while maneuvering in a non-standard visual approach to land. The pilot's misjudgment of his altitude and distance from the airport was due to impairment by alcohol. Factors…NTSB IAD01WA081Accident · 2 fatalForeign investigationCessna T210M · Innsbruck, AustriaNTSB FTW01LA180Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Smith, ARthe overload fracture of the left main landing gear actuator which resulted in the loss of all hydraulic fluid and led to a wheels up landing.NTSB FTW01LA179Accident · 1 fatalLimited investigationFinal reportPdps PZL-Bielsko SZD-55-1 · Uvalde, TXthe pilot's failure to maintain aircraft control during the base turn, which resulted in an inadvertant stall/spin.NTSB DEN01LA145Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B-2 · Cody, WYthe pilot's inadequate in-flight planning for an off site landing, which resulted in failure of the tail rotor drive shaft due to entanglement of his long-line in the drive shaft.NTSB DEN01LA144Accident · No injuriesLimited investigationFinal reportHughes 369FF · Kemmerer, WYfuel exhaustion due to the pilot's failure to refuel the aircraft, which resulted in a loss of engine power. A contributing factor was the unsuitable steep terrain on which to make a forced landing.NTSB CHI01LA280Accident · No injuriesLimited investigationFinal reportCessna 182A · Grosse Ile, MIBoth the CFI and the student pilot on board improperly flared the airplane and the CFI's failure to perform remedial action during the landing.NTSB CHI01LA279Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Traverse City, MIThe pilot not following the emergency landing gear extension procedures. Factors were the failure of the hydraulic motor, and the landing gear locks not engaged.NTSB CHI01LA278Accident · No injuriesLimited investigationFinal reportGremminger 532 Commander · Ste. Genevieve, MOThe inadequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the low altitude and the soft terrain on which the forced landing was made.NTSB CHI01LA275Accident · Serious injuriesLimited investigationFinal reportSchuetz Miniplane DSA-1 · Michigan City, INAircraft control not being maintained by the pilot. Contributing factors to the accident were the pilot maneuvering at a low airspeed, the encountered stall/spin, and the recovery from the spin at a low altitude, which resulted in altitude/clearance not being…NTSB CHI01LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Union, ILThe total failure of the crankshaft as a result of fatigue and the unsuitable terrain encountered during the forced landing. Factors associated with the accident were the soft terrain on which the forced landing was made and the subsequent gear collapse.NTSB SEA01LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Quincy, WAThe failure of the impeller assembly as a consequence of impeller rub and binding within the impeller collector case for undetermined reasons.NTSB NYC01LA209Accident · 2 fatalLimited investigationFinal reportDominiak Kitfox · Byron, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the physiological impairment of the pilot due to the consumption of alcohol.NTSB NYC01LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Gasport, NYThe pilot's failure to obtain a proper climb airspeed which resulted in an inadvertent stall and subsequent impact with a hangar.NTSB LAX01LA276Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Strathmore, CAThe pilot's inadequate visual lookout while maneuvering during an aerial application flight.NTSB IAD01FA096Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Rohrersville, MDThe pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.NTSB FTW01LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Terrell, TXthe flying pilot's failure to maintain control of the airplane during the landing flare which resulted in a hard landing. A contributing factor was the wind shear weather condition.NTSB FTW01LA182Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe loss of engine power while maneuvering for undetermined reasons.NTSB DEN01LA143Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Morgan, UTthe pilot's inadvertent lowering of the flaps and her failure to extend the spoilers.NTSB CHI01LA273Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Hazelton, NDthe pilot's ostentatious display when he performed a low level manuever and stalled the airplane.NTSB ANC01LA112Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Wrangell, AKThe pilot's inadequate evaluation of the weather conditions during a downwind landing at a remote lake. Factors in the accident were a downdraft, rough/uneven terrain, and the pilot's inadequate in-flight planning/decision(s).NTSB ANC01LA109Accident · No injuriesLimited investigationFinal reportSikorsky S61A · Wrangell, AKThe separation of a steel long line cable that failed and rebounded from a load of logs into the helicopter's main and tail rotors.NTSB LAX01MA272Accident · 6 fatalMajor investigationFinal reportEurocopter AS350-B2 · Meadview, AZThe pilot’s loss of control of the helicopter for undetermined reasons.NTSB FTW01LA189Accident · No injuriesLimited investigationFinal reportDonald A Chiasson FP-404 · Port Allen, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA181Accident · No injuriesLimited investigationFinal reportZacharius Acroduster I · Conroe, TXthe mechanic's inadequate inspection which resulted in the undetected corroded rudder cable and its subsequent failure during aerobatic maneuvers.NTSB CHI01LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Milwaukee, WIthe rich fuel mixture and the unsuitable landing area encountered by the pilot. Contributing factors were the high output of the fuel pump and the low altitude.NTSB CHI01FA270Accident · No injuriesField investigationFinal reportBoeing 717-200 · Mascoutah, ILThe malfunction of the nose gear extension system, which resulted from a previous ground collision with a wheel chock. A factor was the wheel chock.NTSB ANC01LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Big Lake, AKThe pilot's selection of an unsuitable area for takeoff.NTSB ANC01LA104Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of an unsuitable area for an off-airport landing.NTSB ANC01FA102Accident · 1 fatalField investigationFinal reportCessna 185 · Tyonek, AKA loss of engine power during cruise flight due to fuel system contamination with water, and the pilot's inadequate preflight procedures. A factor in the accident was unsuitable terrain for a forced landing.NTSB SEA01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Thompson Falls, MTThe pilot's inadequate compensation in gusting wind conditions during the landing flare. A tree was a factor.NTSB NYC01WA207Accident · 2 fatalForeign investigationHughes 369D · Baffin Island, CanadaNTSB MIA01LA213Accident · Serious injuriesLimited investigationFinal reportAvid Mk-4 · Salisbury, NC, An aileron control system failure during climb due to an improper welded installation by the aircraft homebuilder, resulting in an inflight loss of lateral control, and an inflight collision with the terrain during an uncontrolled descent and landing.NTSB MIA01LA212Accident · 2 fatalLimited investigationFinal reportPiper PA-32-260 · Key West, FLThe inadvertent disabling of the throttle in the idle position during a cockpit disturbance created when an armed hijacker forcibly attempted to cause the aircraft to fly to Cuba, resulting in a loss of controllability of power for sustainable flight and an…NTSB MIA01LA211Accident · Serious injuriesLimited investigationFinal reportBeech BE-200 · Sandersville, GAThe pilot-in command's failure to maintain airspeed during the approach, resulting in an inadvertent stall and in-flight collision with the terrain during an uncontrollable descent.NTSB LAX01LA275Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Klamath Falls, ORAn encounter with turbulence from a developing thunderstorm during cruise flight.NTSB FTW01LA178Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Grand Coteau, LAthe loss of engine power while maneuvering, which resulted from a fractured #4 cylinder head at the exhaust valve rocker arm boss. A contributing factor was the lack of suitable terrain for the forced landing.