NTSB investigations, 2000
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\") = 2000 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") = 2000 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 ANC00LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe loss of aircraft control precipitated by the pilot's inadvertent stall. Factors associated with the accident are the disengagement of the stabilizer trim system, which resulted in reduced aircraft control, an inadvertent stall by the pilot, and a large…NTSB ANC00LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot's inadvertent stall/mush during the final approach to land. Factors associated with the accident are the pilot's misjudged flare, and the rough and uneven terrain.NTSB LAX00LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Payson, AZThe pilot's failure to maintain directional control during the takeoff roll due to over-rotation, inadequate airspeed, and improper remedial action under the high density altitude condition.NTSB IAD00FA082Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Carrollton, OHPilot's improper decision to delay the aborted landing, which resulted in an insufficient airspeed during climb and subsequent collision with terrain. A factor was the wet runway and tailwind.NTSB FTW00LA255Accident · No injuriesLimited investigationFinal reportMooney M20 · Owasso, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA167Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.NTSB CHI00LA308Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hallock, MNthe pilot not maintaining directional control of the airplane. Factors were the gusts, the crosswind weather conditions, and the ditch terrain condition.NTSB CHI00LA296Accident · No injuriesLimited investigationFinal reportBoeing 727-224 · Minneapolis, MNThe fatigue failure of the wheel assembly. A factor was the inadequate inspection procedures prior to the issuance of a service bulletin.NTSB CHI00LA294Accident · No injuriesLimited investigationFinal reportBeech B24 · Necedah, WIThe pilot did not properly flare the airplane during the aborted takeoff and he failed to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the partial power loss for undetermined reasons and the…NTSB ATL00LA089Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · St. Augustine, FLThe loss of engine power due to fuel system contamination.NTSB ATL00LA088Accident · No injuriesLimited investigationFinal reportCessna 188 · Tampa, FLThe failure of the number six-piston connecting rod that resulted in the total loss of engine power.NTSB SEA00LA184Accident · No injuriesLimited investigationFinal reportMooney M20L · Hailey, IDThe pilot's inadequate compensation for the wind conditions. A crosswind condition was a factor.NTSB NYC00LA258Accident · Serious injuriesLimited investigationFinal reportBeech 33-F33A · Warwick, NYThe pilot's improper decision to fully retract flaps during a go-around.NTSB MIA00FA265Accident · 2 fatalField investigationFinal reportBeech 58P · Brookhaven, MSThe poor in-flight planning/decision by the pilot for flying a close-in downwind leg, improper aircraft handling by the pilot for his executing a 70-75 degree angle of bank turning base to final while circling to land, and inadvertent stall/mush of the…NTSB LAX00LA332Accident · No injuriesLimited investigationFinal reportCessna 120 · Sacramento, CAThe pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…NTSB LAX00LA331Accident · 2 fatalLimited investigationFinal reportE. J. Humphrey Christen Eagle II · Lake Elsinore, CAThe pilot's failure to maintain clearance from ground obstacles that resulted in an in-flight collision with a tree, while intentionally maneuvering at a low altitude, and the pilot's inattentive visual lookout.NTSB FTW00RA262Accident · 1 fatalForeign investigationDornier DO-28D-2 · Manta, EcuadorNTSB CHI00LA291Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Moorehead, MNThe pilots failure to abort the takeoff and the airplane not attaining a proper climb rate for undetermined reasons.NTSB ATL00LA090Accident · No injuriesLimited investigationFinal reportJack McDaniel Rans S12XL · Homestead, FLThe pilot's improper flare during landing which collapsed the landing gear.NTSB ATL00LA087Accident · No injuriesLimited investigationFinal reportGrumman G164A · Dillon, SCA total loss of engine power due to a cracked cylinder head. A factor was the emergency landing into unsuitable terrain, and the subsequent nose over.NTSB ATL00LA086Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Pine Hill, ALThe pilot's failure to adequately preflight the helicopter, which resulted in his failure to remove the tie down.NTSB NYC00LA261Accident · Minor injuriesLimited investigationFinal reportCarlson CA-8 · East Palestine, OHFuel starvation as a result of the pilot's inadequate pre-flight inspection. A factor in this accident was the inadequate marking of the fuel selector valve to clearly indicate a fully open position.NTSB NYC00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cross Keys, NJThe operator's inadequate 100-hour inspection of the airplane, and the pilot's continued operation with known deficiencies in equipment.NTSB NYC00LA255Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Laconia, NHThe pilot's failure to maintain aircraft control. A factor in the accident was the large wave.NTSB DEN00LA168Accident · No injuriesLimited investigationFinal reportCessna A185F · Ruidoso, NMthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind weather condition.NTSB DEN00LA166Accident · No injuriesLimited investigationFinal reportCessna 340A · Big Piney, WYCollision with animals during the takeoff roll.NTSB CHI00LA292Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Ellington, MOThe pilot's failure to maintain control of the aircraft during the aborted landing. Contributing to the accident was the rich mixture caused by an obstruction in the regulator section of the fuel servo.NTSB CHI00LA290Accident · No injuriesLimited investigationFinal reportBeech B19 · Dodge Center, MNthe student pilot not maintaining aircraft control and the instructor pilot's delayed remedial action. A factor relating to the accident was the ditch.NTSB CHI00FA288Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Custer, SDThe pilot not maintaining clearance from the tree. Factors relating to this accident were the pilot's inadequate preflight planning and preparation, the high density altitude, the inadequate rate of climb, the pilot's improper in-flight decision to fly into…NTSB ANC00LA117Accident · No injuriesLimited investigationFinal reportCessna 180 · Sterling, AKThe pilot's failure to attain clearance from trees during takeoff from a touch-and-go landing. A factor associated with the accident is the pilot's failure to attain a proper touchdown point.NTSB NYC00WA260Incident · No injuriesForeign investigationMcDonnell Douglas DC-10-30 · Amsterdam, NetherlandsNTSB NYC00LA254Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's failure to attain the proper touchdown point.NTSB NYC00LA253Accident · No injuriesLimited investigationFinal reportCessna 177RG · Elmer, NJThe instructor's failure to take remedial action.NTSB NYC00LA252Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Northampton, MAThe pilot's improper preflight planning which resulted in an attempted takeoff from a taxiway. A factor in the accident was the fog.NTSB MIA00GA264Accident · 2 fatalFinal reportBell UH-1H · Waynesville, NCAn in-flight encounter with ground level fog due to the pilot's decision to continue VMC flight into instrument conditions, resulting in an in-flight collision with trees.NTSB LAX00LA329Accident · No injuriesLimited investigationFinal reportBeech A36TC · Minden, NVthe failure of the pilot to follow the pilot operating handbook procedures and to refuel the airplane.NTSB LAX00LA328Accident · 1 fatalLimited investigationFinal reportHughes 269C · Rancho Murieta, CAThe pilot's inadequate visual lookout during cruise, which subsequently led to a wire strike.NTSB IAD00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Headwaters, VAPilot's failure to maintain aircraft control during take-off, which resulted in a stall.NTSB FTW00LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mountain Home, ARThe failure of the landing gear to extend due to the empty hydraulic reservoir.NTSB FTW00LA253Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Erick, OKthe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA252Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Eugene Is 296bThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB IAD00WA083Accident · 2 fatalForeign investigationLockheed C-130A · Aubenas, FranceNTSB FTW00LA257Accident · No injuriesLimited investigationFinal reportAir Tractor 402B · Segraves, TXThe pilot's failure to maintain clearance with the irrigation system. A factor was the whirlwind weather condition.NTSB FTW00LA251Accident · No injuriesLimited investigationFinal reportBeech BE58 · Bethany, OKthe fire, which ignited in the engine compartment for undetermined reasons while taxiing.NTSB FTW00LA250Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Farwell, TXThe loss of engine power for undetermined reasons. Factors were the smoke in the cockpit, and the lack of suitable terrain for the forced landing.NTSB DEN00LA165Accident · Serious injuriesLimited investigationFinal reportGulfstream G-IV · Sheridan, WYthe pilot's inadvertent flight into unforecasted turbulent weather conditions. A contributing factor was the turbulence.NTSB ANC00LA115Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable, rough, runway. Factors were the crosswind, the pilot's inexperience, the company's inadequate surveillance of their operation, and dispatch of an inexperienced pilot to the unsuitable airport.NTSB NYC00IA250Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJThe sequential failure of the 2nd-stage low pressure turbine nozzle locks, which allowed the 2nds stage turbine nozzle segments to rotate within the low pressure turbine case, machining a hole whereby the nozzle segments exited the engine. A factor was the…NTSB LAX00LA325Accident · No injuriesLimited investigationFinal reportWilliams Williams Mite M18L · San Diego, CAThe separation of the airplane's vertical stabilizer and rudder assemblies, during the landing approach, because of dry rot.NTSB FTW00LA254Accident · No injuriesLimited investigationFinal reportAbernathy Streaker · Sherman, TXThe failure of the wing skin and the rear spar while performing aerobatics, which resulted in the restricted movement of the aileron.