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 NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.NTSB CHI01LA005Accident · No injuriesLimited investigationFinal reportCessna T210N · Cahokia, ILaircraft control not being maintained by the inattentive pilot during the taxi. A factor to the accident was the soft terrain condition.NTSB ANC01LA009Accident · No injuriesLimited investigationFinal reportCurtis-Wright C-46F · Port Alsworth, AKThe pilot's failure to maintain clearance during taxi. A factor associated with the accident was trees.NTSB NYC01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Marshfield, MAThe pilot's improper management of the fuel supply, which resulted in fuel starvation of the engine. A factor in the accident was the pilot's diverted attention to the inclement weather.NTSB LAX01FA003Accident · 1 fatalField investigationFinal reportCessna 182S · Santa Rosa, CAthe pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.NTSB FTW01LA005Accident · 2 fatalLimited investigationFinal reportHolt Thorpe T-18C · Imperial, TXthe failure of the propeller blade due to fatigue, which originated from a corrosion crack. A contributory factor was the pilot/owner's failure to ensure that the propeller was overhauled at the manufacturer's recommended interval.NTSB CHI01LA002Accident · 1 fatalLimited investigationFinal reportMoseler RAF 2000 GTX SE · Muskegon, MIThe main rotor contacting with the vertical stabilizer, the loss of the vertical stabilizer, and the aircraft control not possible by the pilot.NTSB LAX01LA009Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · El Cajon, CAImproper torquing procedure of the aft tail rotor drive shaft coupling by maintenance personnel after tracking the tail rotor.NTSB LAX01LA002Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Long Beach, CAThe dual student's improper use of the collective and the flight instructor's inadequate supervision during the practice hovering autorotation maneuver. A factor was the underlying soft dirt terrain, which promoted the rollover event.NTSB CHI01FA001Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Rapid City, SDSuicideNTSB ATL01LA004Accident · No injuriesLimited investigationFinal reportJoseph A. Grimaud Seawind 3000 · Chapin, SCA total loss of engine power for undetermined reasons. A factor was the trees.NTSB ATL01LA003Accident · 1 fatalLimited investigationFinal reportUniversity of Alabama MINI-500 · Tuscaloosa, ALThe loss of engine power for undetermined reasons, and the pilot's unapproved airframe modification that resulted in the loss of flight control during the emergency descent.NTSB NYC01LA002Accident · Serious injuriesLimited investigationFinal reportMaule M-5 · Leicester, MAThe pilot's failure to properly manage the fuel onboard the airplane, which resulted in fuel starvation, and a total loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while maneuvering for a field.NTSB LAX01FA001Accident · 4 fatalField investigationFinal reportBeech A36TC · San Juan Batist, CAthe pilot's in-flight decision to continue flight into instrument weather conditions at an altitude that did not maintain an adequate terrain clearance, which resulted in a collision with terrain. Factors were a dark night, clouds, fog, mountainous terrain,…NTSB FTW01LA004Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Jasper, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.NTSB ATL01LA005Accident · Serious injuriesLimited investigationFinal reportAlvin R. Kemmet Tango 2 · New Port Richey, FLThe uncertified pilot's improper recovery from a bounced landing which resulted in the collapse of the nose gear asasembly and subsequent nose over. Factors were the pilot's lack of certification and the runway light.NTSB ANC01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Naknek, AKThe pilot's selection of an unsuitable takeoff area. Factors associated with the accident were wet and soft terrain.NTSB NYC01FA001Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Seven Springs, PAThe pilot's improper recovery from a bounced landing.NTSB LAX00FA354Accident · 1 fatalField investigationFinal reportPiper PA-38 · San Luis Obispo, CAThe pilot's failure to maintain clearance from terrain while turning to reverse course following inadvertent nighttime flight into instrument meteorological conditions. A factor in the accident was the pilot's lack of experience in nighttime operations.NTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.NTSB FTW01WA010Accident · 2 fatalForeign investigationCessna TU-206F · San Mateo, MexicoNTSB FTW01LA001Accident · No injuriesLimited investigationFinal reportCessna 150L · Nashville, ARThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DEN01LA001Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Ogden, UTThe pilot's failure to maintain a proper descent rate during landing flare/touchdown. A factor was the tail wheel failure due to overload.NTSB ATL01LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Boone, NCThe pilot's misjudgment of speed and distance which resulted in an overrun of the runway. A contributing factor was the tailwind condition.NTSB ATL01IA001Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Birmingham, ALThe failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.NTSB SEA00LA195Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salem, ORThe pilot's failure to maintain aircraft control upon experiencing a loss of normal braking effectiveness. Factors included a partial failure of the brake system, a tailwind, and a parked aircraft.NTSB MIA00RA275Accident · 1 fatalForeign investigationRobinson R-44 · Carlos Tejedor, ArgentinaNTSB FTW00LA272Accident · Serious injuriesLimited investigationFinal reportPorterfield LP65 · Corsicana, TXThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion. A factor was the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB FTW00LA271Accident · No injuriesLimited investigationFinal reportTemco Luscombe 11A · Hammond, LAthe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A contributory factor was the fuel cap leak, due to a worn seal.NTSB DEN00LA183Accident · 2 fatalLimited investigationFinal reportErcoupe 415-C · Tucumcari, NMloss of control during initial climb following takeoff by an unqualified person.NTSB DEN00FA182Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Telluride, COthe pilot's failure to maintain aircraft control while maneuvering, and the subsequent inadvertent stall/spin to the ground. A contributing factor was the high density altitude weather condition.NTSB CHI00LA311Accident · No injuriesLimited investigationFinal reportCessna 150H · Michigan City, INfuel contamination (water) and the pilot exceeding his landing field distance. Factors relating to this accident were the pilot inadequate preflight planning/preparation, his having to select an unsuitable landing area, the short landing area, and the marsh.NTSB ATL00LA095Accident · 2 fatalLimited investigationFinal reportWilliam J. Knowles KNOWLES-THORP KT-18 · Opa-Locka, FLThe pilot's failure to maintain flying airspeed during initial climb, resulting in an inadvertent stall/spin.NTSB ATL00LA094Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Homosassa, FLThe pilot's inadvertent flight into instrument meteorological conditions and subsequently exhausting his fuel supply. Factors were his failure to obtain a weather briefing, the weather conditions which included clouds and obscuration, the residence and the…NTSB NYC00LA269Accident · No injuriesLimited investigationFinal reportSaab 340B · Boston, MAThe operator's loss of control of the belt-loader, due to his improper decision to depress the vehicle's accelerator in the proximity of the airplane.NTSB LAX00WA353Accident · Minor injuriesForeign investigationCessna 340 · Nadi, FijiNTSB LAX00TA355Accident · No injuriesFinal reportHughes TH-55A · Phoenix, AZthe flight instructor's misjudged flare during a simulated autorotation, which led to a hard landing.NTSB FTW00LA270Accident · 1 fatalLimited investigationFinal reportCessna 188B · Stanton, TXThe pilot's failure to maintain clearance from guy wires and tower.NTSB DEN00LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Erie, COInadequate supervision by the certified flight instructor. Factors were loss of control by the student pilot, the flight instructor's failure to properly monitor the student pilot's rate of descent on final approach, and the flight instructor's lack of recent…NTSB DCA00WA093Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Subic Bay, PhilippinesNTSB CHI00LA310Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Petersburg, MIthe pilots failure to abort the takeoff and obtain/maintain clearance from the corn crop. Factors were the tall, wet, grass runway, and the corn crop.NTSB ANC00LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Slana, AKThe pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.NTSB SEA00WA196Accident · 3 fatalForeign investigationCessna A185F · Smithers, CanadaNTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.NTSB MIA00WA274Accident · 1 fatalForeign investigationCessna 185 · Vargas, VenezuelaNTSB LAX00LA352Accident · Minor injuriesLimited investigationFinal reportMooney M20S · San Carlos, CAThe pilot's failure to maintain directional control of the airplane during an aborted landing.NTSB SEA00LA193Accident · No injuriesLimited investigationFinal reportHughes 269B · Laurel, MTFailure to maintain aircraft control during hover operations. Inadequate remedial action by the pilot was a factor.NTSB SEA00LA192Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Columbia River, WAClearance from a transmission power line was not maintained. The power line was a factor.NTSB SEA00LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miles City, MTA loss of engine power for undetermined reasons.NTSB MIA00LA272Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Gulfport, MSa loss of power on both engines, during a simulated engine out approach, resulting in a forced landing and the subsequent on ground impact with a pole.