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 FTW00LA220Accident · No injuriesLimited investigationFinal reportAero Tek Zuni · Uvalde, TXThe pilot's inadvertent flight into adverse weather conditions which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB ATL00LA070Accident · 2 fatalLimited investigationFinal reportLeslie Briggs Glasair III · Smithfield, NCThe pilot's failure to maintain flying speed during an emergency landing which lead to an inadvertent stall/spin. A factor was the pilot's failure to secure the cockpit canopy prior to takeoff.NTSB SEA00LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birkenfeld, ORThe pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.NTSB NYC00LA213Accident · 2 fatalLimited investigationFinal reportSchwarz Zodiac CH 601 · Wooster, OHThe pilot's loss of control of the airplane while turning from base onto final, which resulted in an inadvertent stall/spin. A factor was the pilot's improper loading of the airplane, outside the weight and balance limitations.NTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.NTSB FTW00LA227Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rayville, LAThe flight instructor's failure to maintain directional control. A factor was the wind gusts.NTSB FTW00LA219Accident · 1 fatalLimited investigationFinal reportLet L-23 Super Blankit · Waller, TXthe pilot's failure to maintain control of the glider while maneuvering. Contributory factors were the in-flight separation of the tow rope and the pilot's physical impairment from his use of diphenhyrdramine.NTSB FTW00LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Calico Rock, ARthe pilot's inability to maintain airplane control during the landing roll due to the airplane hydroplaning on the wet runway.NTSB DEN00LA142Accident · No injuriesLimited investigationFinal reportMooney M20E · Canon City, COThe pilot's failure to extend the landing gear, which resulted in a wheels up landing.NTSB DEN00LA140Accident · No injuriesLimited investigationFinal reportCessna A188 · Gallup, NMThe pilot's failure to compensate for the wind conditions. Factors were the pilot's selection of the wrong runway, and the tailwind/crosswind weather conditions.NTSB CHI00LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INthe non-pilot rated passenger's improper flare and not relinquishing the controls, and the pilot's inadequate remedial action and the pilot's poor decision to practice instruction with an unqualified pilot prior to becoming a Certified Flight Instructor.NTSB CHI00FAMS2Accident · 1 fatalMissing aircraftFinal reportPeters RAF 2000 · Manistique, MIundetermined.NTSB ATL00LA071Accident · Minor injuriesLimited investigationFinal reportRyskamp Sonex · Greenville, SCThe pilot's misjudgment of airspeed and altitude resulting in an undershoot.NTSB SEA00LA147Accident · No injuriesLimited investigationFinal reportCessna A185F · Tillamook, ORThe pilot's failure to maintain directional control.NTSB SEA00LA145Accident · No injuriesLimited investigationFinal reportRoot Sherpa · Helena, MTThe pilot's failure to maintain directional control while landing.NTSB NYC00LA212Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Chatham, MAThe pilot's delayed use of the brakes, which resulted in a runway overrun. Factors in the accident were the pilot's improper decision to land with a right quartering tailwind.NTSB LAX00LA281Accident · No injuriesLimited investigationFinal reportCessna 180 · North Las Vegas, NVThe pilot's improper recovery from a bounced landing and subsequent failure to maintain directional control of the aircraft. Wind shear on landing approach was a factor in the accident.NTSB LAX00LA280Accident · No injuriesLimited investigationFinal reportBell 47G-5 · King City, CAThe pilot's intentional flight into adverse weather which resulted in loss of visual reference and flight into power transmission wires and terrain.NTSB CHI00LA230Accident · No injuriesLimited investigationFinal reportBell BH-222-U · St. Paul, MNthe pilot's inadequate preflight and improper vertical takeoff and not obtaining clearance from helicopter pad light. Factors included the tailwind takeoff and the helipad light.NTSB CHI00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Harbor Springs, MIthe pilot selected the wrong runway direction in which to land and he did not perform a go-around when he realized the landing approach was too high. Factors associated with the accident were the tailwind condition, the improper glidepath, and the intentional…NTSB CHI00FA229Accident · No injuriesField investigationFinal reportCessna 195A · Oshkosh, WIThe pilots failure to maintain directional control. A factor was the landing gear being out of alignment.NTSB CHI00FA227Accident · 4 fatalField investigationFinal reportCessna 182A · Sauk City, WIVFR flight into IMC encountered by the pilot and exceeding the design limits of the aircraf. A factor was flight to a destination alternate not performed by the pilot.NTSB ATL00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Charleston, SCThe pilot's inadequate evaluation of weather information, and his delay in taking remedial action that resulted in the in-flight encounter with severe weather.NTSB LAX00LA299Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakland, CAThe pilot's improper landing flare.NTSB LAX00LA279Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Phoenix, AZThe helicopter had a tail rotor failure. The reason for the failure is undetermined.NTSB FTW00LA221Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kingfisher, OKThe pilot's failure to maintain aircraft control. A factor was the downdraft weather condition.NTSB FTW00LA217Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Olney, TXThe pilot's inadequate compensation for wind conditions. A factor was the gusty crosswind.NTSB DEN00FA141Accident · 1 fatalField investigationFinal reportMooney M20K · Cheyenne, WYthe airplane's in-flight collision with hilly terrain for undetermined reasons.NTSB CHI00LA226Accident · 1 fatalLimited investigationFinal reportHalsmer Crazy 8 · Lafayette, INAircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the engine failure due to an overtemperature, the pilot's lack of familiarity with the aircraft, and the trees.NTSB SEA00LA144Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20E · Hamilton, MTThe pilot's entering an inadvertent stall condition during a high angle of bank turn (maneuvering), and the lack of adequate altitude in which to successfully recover before ground impact.NTSB NYC00LA178Accident · No injuriesLimited investigationFinal reportCianchette Lionheart · Batavia, NYThe pilot's failure to attain adequate airspeed before liftoff, which resulted in a stall/mush. A factor was the pilot's lack of experience in the type of airplane.NTSB NYC00FA210Accident · 1 fatalField investigationFinal reportMooney M20E · Lunenburg, MAThe pilot's inadequate preflight planning which resulted in exhaustion of the fuel supply.NTSB NYC00FA209Accident · 1 fatalField investigationFinal reportCessna 210D · Ashland, VAThe failure of the pilot to maintain control of the airplane due to spatial disorientation. Factors were the dark night, low ceiling and fog.NTSB LAX00LA278Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons.NTSB CHI00LA225Accident · Minor injuriesLimited investigationFinal reportComeau Avid Flyer · Gladstone, MIaircraft control not maintained by the pilot.NTSB CHI00LA224Accident · Minor injuriesLimited investigationFinal reportBohner Pitts Model 12 · Neosho, MOThe unsuitable terrain the pilot selected during his emergency landing. Factors were the hay rolls and the loss of engine power for undetermined reasons.NTSB ANC00LA098Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for crosswind conditions.NTSB SEA00FA142Accident · 1 fatalField investigationFinal reportCessna TU-206G · Pistol Creek, IDA loss of engine power due to the fracture of the #2 cylinder intake valve stem and the puncturing of the #2 piston dome by the intake valve head. Factors include no suitable landing site within the maneuvering abilities of the aircraft, and coniferous trees…NTSB MIA00LA225Accident · No injuriesLimited investigationFinal reportCessna 421A · Homewood, MSThe inadequate installation of the right propeller by the mechanic for his failure to properly torque the eight nuts resulting in fatigue failure of the studs and separation of the right propeller during cruise flight. Findings in the investigation were 1)…NTSB FTW00LA216Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Sherman, TXthe total failure of the clutch cable during landing, which resulted from fatigue cracking of the cable's individual wires.NTSB DEN00LA139Accident · No injuriesLimited investigationFinal reportFudold Avid - Magnum · Walden, COThe pilot's inadvertent stall/mush during a go-around attempt. A contributing factor was the high density altitude weather condition.NTSB DCA00RA078Accident · 113 fatalForeign investigationAerospatiale Concorde Version 101 · Paris-Gonesse, FranceNTSB CHI00LA222Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Oshkosh, WIthe pilot failed to maintain control of the airplane during flare/touchdown.NTSB CHI00LA216Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOthe excessive brakes applied by the second pilot. A factor to the accident was the unavailability of brakes on the flight instructor's side of the aircraft.NTSB ANC00LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's excessive application of the airplane's brakes.NTSB DEN00LA153Accident · No injuriesLimited investigationFinal reportMooney M20C · Erie, COFailure by the pilot to follow procedures and lower the landing gear.NTSB CHI00LA223Accident · No injuriesLimited investigationFinal reportCessna 210N · Harrisburg, ILThe power loss for undetermined reasons and unsuitable terrain.NTSB CHI00LA218Accident · No injuriesLimited investigationFinal reportYakovlev YAK 52 · Mooresville, INthe brakes not available to the pilot. Factors were the improperly serviced brake system, the improper adjustment of the brakes by maintenance personnel, the trees, and the pilot's decision not to use the available alternate airport.NTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.NTSB SEA00LA143Accident · Serious injuriesLimited investigationFinal reportJim Weseman Challenger II · Chiloquin, ORLoss of engine power for undetermined reasons. Unsuitable terrain and the pilot's failure to maintain aircraft control were factors.