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 NYC00FA225Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Cherry Valley, NYThe pilot's improper decision to continue the flight into deteriorating weather, which resulted in his failure to maintain control of the airplane. Factors in the accident were the dark night, fog, low ceiling, and the pilot's inadequate preflight planning.NTSB MIA00WA236Accident · No injuriesForeign investigationBeech B200 · Spanish Cay, BahamasNTSB LAX00LA296Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carlsbad, CAA catastrophic internal engine failure for undetermined reasons.NTSB LAX00LA295Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newell, CAA hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.NTSB LAX00LA294Accident · No injuriesLimited investigationFinal reportDickenson Avid Magnum · Ely, NVThe pilot's inadequate compensation for a gusting crosswind that resulted in a loss of directional control and subsequent collision with the ground.NTSB LAX00LA293Accident · 2 fatalLimited investigationFinal reportBarclay/Vincent Murphy SR 2500 · Bakersfield, CAAdjustment by other maintenance personnel of the idle speed stop screw. The idle speed stop screw was backed off from the throttle shaft arm, not allowing the butterfly valve to operate properly, which resulted in the butterfly valve remaining closed during a…NTSB IAD00LA073Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kidron, OHthe pilot's failure to maintain a proper glide path and proper visual lookout that resulted in collision with wires.NTSB FTW00IA228Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · San Angelo, TXthe improper installation of the right elevator trim control wheel by company mechanics, which resulted in an elevator trim malfunction.NTSB DEN00LA150Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Edwards, COLack of crew coordination when the ground crew failed to hold the balloon in position following landing as the pilot expected them to do. A factor was power lines.NTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB CHI00LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Coopersville, MIfuel starvation due to the blocked carburetor. Factors relating to the accident were the foreign object (tab), the improper maintenance performed on the carburetor, and the corn crop.NTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.NTSB ANC00LA101Accident · Minor injuriesLimited investigationFinal reportHaskins CHALLENGER-2 · Central, AKThe pilot's inadequate evaluation of the winds, and his intentional attempt to takeoff into the known adverse weather. Factors associated with this accident were the gusty crosswind conditions.NTSB ANC00LA099Accident · No injuriesLimited investigationFinal reportCessna 185F · Barrow, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a hidden obstruction, and soft terrain.NTSB ANC00LA097Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Port Alsworth, AKThe pilot's failure to touchdown at the proper point on the landing area. Factors associated with this accident were the rough landing area, and the brush along the gravel bar.NTSB SEA00LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802F · Salmon River, IDCompressor turbine blade failure due to high-cycle fatigue initiating in the surface of the fir-tree root. Factors include unsuitable terrain for an emergency landing.NTSB LAX00RA327Accident · No injuriesForeign investigationHughes 369HS · Cape Town, South AfricaNTSB LAX00LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly II · Phoenix, AZThe pilot's failure to use pibals or other on site wind determination devices, and his subsequent failure to detect adverse wind conditions prior to launch of the balloon.NTSB DEN00LA148Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albuquerque, NMthe failure of both pilots to maintain visual lookout. A contributing factor was the pilot not following recommended traffic pattern procedures.NTSB SEA00LA157Accident · No injuriesLimited investigationFinal reportHamer Lancair 235 · Chiloquin, ORLoss of engine power due to a fracture and separation of the engine's crankshaft. A factor was a vehicle on the roadway.NTSB SEA00LA156Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn inadequately planned approach. The encounter of wake turbulence and not being able to maintain aircraft control were factors.NTSB NYC00LA224Accident · Minor injuriesLimited investigationFinal reportCessna 150 · East Moriches, NYThe pilot's failure to maintain a climb during climbout. A factor in the accident was the pilot's failure to reconfigure the flaps for the aborted landing.NTSB MIA00LA237Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Perthshire, MSthe pilot's failure to perform a weight and balance check that resulted in overloading of the airplane with spraying material, for the weather conditions that existed at the time of takeoff. Factors in this accident were extremely high temperatures, which…NTSB MIA00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Crossville, TNThe pilot's inadequate compensation for wind and his failure to maintain obstacle clearance. The crosswind was a contributing factor.NTSB LAX00LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain proper glide path. A factor in the accident was the upsloping runway and nature of the terrain around the runway, which presented an optical illusion and lead…NTSB IAD00LA072Accident · Serious injuriesLimited investigationFinal reportAero Commander 114-B · Somerset, PAPilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB DEN00LA147Accident · Minor injuriesLimited investigationFinal reportFisher Glastar GS-1 · Berthoud, COThe pilot's failure to maintain obstacle clearance during takeoff. A factor was the irrigation equipment.NTSB CHI00LA255Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Omaha, NEthe landing gear not deployed, the checklist not followed, the lack of familiarity with the airplane, the landing gear warning system not understood, and the landing gear warning disregarded by the pilot.NTSB CHI00LA252Accident · No injuriesLimited investigationFinal reportCessna 182Q · Warsaw, MOInadequate maintenance and the pilot's failure to maintain airspeed which resulted in failure of the carburetor and an inadvertent stall.NTSB ANC00LA116Accident · No injuriesLimited investigationFinal reportCessna 207A · Aniak, AKThe pilot's inadequate recovery from a bounced landing. Factors in the accident were the pilot's inadequate preflight planning/preparation, insufficient information about the landing strip from company personnel, inadequate oversight of the flight by company…NTSB SEA00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gleneden Beach, ORThe pilot's failure to remove the control lock during his preflight inspection. Factors contributing to the accident were the pilot's failure to follow the BEFORE TAKEOFF checklist, trees beyond the upwind end of the runway, and the pilot's self-induced…NTSB NYC00LA223Accident · No injuriesLimited investigationFinal reportCessna 150 · Bridgewater, MAThe mechanic's inadequate annual inspection, which resulted in a departure with fuel contamination. A factor was the pilot-in-command's inadequate preflight inspection.NTSB LAX00LA290Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe student pilot's inadequate preflight planning which included improper fuel consumption calculations that led to fuel exhaustion and loss of engine power during takeoff.NTSB DCA00MA080Accident · 11 fatalMajor investigationFinal reportPiper PA-31 Navajo · Burlington Twp., NJthe failure of the pilots of the two airplanes to see and avoid each other and maintain proper airspace separation during visual flight rules flight.NTSB CHI00WA251Accident · 3 fatalForeign investigationCessna 340X · Hessen, GermanyNTSB ANC00LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe pilot's inadequate preflight planning/preparation. Factors in the accident were an uphill takeoff, high vegetation, and a short runway area.NTSB NYC00LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Chester, CTThe CFI's delayed remedial action.NTSB MIA00LA234Accident · 1 fatalLimited investigationFinal reportEachon Time Warp Spitfire 9 · Lakeland, FLa loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…NTSB DCA00MA079Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9-32 · Greensboro, NCA phase-to-phase arc in the left heat exchanger cooling fan relay, which ignited the surrounding wire insulation and other combustible materials within the electrical power center panel. Contributing to the left heat exchanger fan relay malfunction was the…NTSB CHI00WA283Accident · Minor injuriesForeign investigationCessna T210 · Salzburg, AustriaNTSB CHI00LA247Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wallace, NEthe fractured number three exhaust push rod assembly and the unsuitable terrain encountered by the pilot.NTSB ATL00TA080Accident · No injuriesFinal reportBell OH-58C · Tampa, FLThe pilot's improper use of flight controls that resulted in low rotor induced oscillation during a practice autorotation.NTSB ATL00LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manteo, NCThe pilot's failure of preflight planning preparation, which resulted in the fuel exhaustion, and the subsequent loss of engine power.NTSB SEA00LA153Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Challis, IDThe pilot's inadequate compensation for wind conditions. Factors include variable winds during landing.NTSB NYC00WA222Accident · 3 fatalForeign investigationCessna 210L · Reykjavik, IcelandNTSB FTW00LA225Accident · Minor injuriesLimited investigationFinal reportBrown/Morrison Rans S-12 · Bonham, TXThe pilot's failure to maintain control of the airplane while maneuvering to return to the airport. Factors were the gusty wind conditions and the pilot's lack of experience.NTSB SEA00LA152Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Stanley, IDAn inadequately performed short field landing procedure and excessive ground speed. A delayed corrective response from the flight instructor, tailwind condition, and a fence were factors.NTSB NYC00LA218Accident · No injuriesLimited investigationFinal reportBeech BE-58 · West Milford, NJThe pilot's failure to maintain directional control during the landing flare and touchdown, which resulted in a blown tire, and a continued loss of directional control during the landing roll.NTSB NYC00LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · E. Stroudsburg, PAThe pilot's decision to takeoff with only partial engine power available.NTSB MIA00LA233Accident · No injuriesLimited investigationFinal reportCessna 188B · Washington, NCa loss of engine power for undetermined reason, resulting in a forced landing, and subsequent impact with a ditch.