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 MIA01LA020Accident · No injuriesLimited investigationFinal reportJohn S. Eberle Pitts Special S1S · Sebring, FLImproper inspection of the tailwheel assembly by the pilot which resulted in shimmy of the tailwheel assembly during landing due to a worn bearing caused by dirt infiltration which resulted in the pilot being unable to control the airplane and the airplane…NTSB LAX01LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gorman, CAthe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. A contributing factor was the pilot's use of impairing medications.NTSB IAD01WA010Accident · Minor injuriesForeign investigationPiper PA-60 · Koblenz, GermanyNTSB DEN01LA012Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mesa Verde, COThe manufacturer's use of improper materials, and inadequate quality control of the tail rotor blades during the manufacturing process, which resulted in fatigue failure of the blade.NTSB DEN01LA010Accident · No injuriesLimited investigationFinal reportOtero-Pitts PT1 · Albuquerque, NMA hard landing, which exceeded the design stress limits of the aircraft. Factors were the pilot's lack of experience in aircraft make and model and improper recovery from a bounced landing.NTSB CHI01LA027Accident · Minor injuriesLimited investigationFinal reportForney F1A · Austin, MNthe proper glide path not being maintained by the pilot which resulted in the proper touchdown point not being obtained during the approach. A factor to the accident was the rising embankment.NTSB LAX01LA031Accident · No injuriesLimited investigationFinal reportCessna 182S · French Valley, CAThe pilot's failure to follow procedures and directives contained in the information manual. Contributing to the accident was the flight instructor examiner/passenger's inattention to the sequence of events.NTSB IAD01WA011Accident · No injuriesForeign investigationRobinson R 22 · Wallforf, GermanyNTSB DEN01LA009Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Greeley, COCarburetor ice formation due to the pilot's improper use of the carburetor heat control. Factors were the fence and fence post.NTSB DEN01LA008Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMthe pilot's failure to follow procedures/directives and lower the landing gear for landing. Contributing factors were the damaged propellers making it impossible to perform a go-around, the inadvertent stall to the runway, and the pilot being in a state of…NTSB CHI01LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Carrollton, MOthe misjudged touchdown point by the pilot. Factors were the runway lights not on, the dark night, and the plowed field.NTSB SEA01LA010Accident · No injuriesLimited investigationFinal reportCessna 150C · Sunnyslope, WAThe pilot's decision not to deviate to an alternate airport for fuel after encountering strong headwinds, resulting in fuel exhaustion. Factors contributing to the accident were the unfavorable winds and the sign impacted during the forced landing rollout.NTSB FTW01FA017Accident · 1 fatalField investigationFinal reportAerospatiale AS-350BA · E. Cameron 200the loss of engine power due to an internal engine oil leak that started an internal engine fire and the pilot's inadequate autorotation which resulted in a hard landing. A contributing factor to the accident was the rough water condition.NTSB DEN01LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Collins, COFailure by the pilot to follow instrument approach procedures and execute a missed approach when the runway environment was not in sight at decision height. A factor was low ceiling.NTSB ANC01LA014Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe pilot's inadequate compensation for a bounced landing, and failure to maintain directional control of the airplane. A factor in the accident was flat lighting conditions.NTSB ANC01LA013Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Juneau, AKThe pilot's failure to refuel the airplane, and his inadequate preflight planning/preparation. A factor associated with the accident was the pilot's selection of an unsuitable landing area.NTSB NYC01LA027Accident · No injuriesLimited investigationFinal reportO Loughlin WAG-A-BOND · Greenville, METotal loss of engine power for undetermined reasons.NTSB MIA01LA019Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to maintain directional control during landing with a quartering tail wind, resulting in the aircraft nosing over and coming to rest inverted.NTSB MIA01FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 150 · Missing, FLundetermined.NTSB NYC01IA024Incident · No injuriesIncident investigationFinal reportBombardier CL-600 · Falmouth, KYThe wake turbulence of another heavy airplane.NTSB MIA01LA018Accident · No injuriesLimited investigationFinal reportMooney M-20J · Deland, FLthe dual student's improper use of the brakes and the flight instructor's inadequate supervision which resulted in a loss of directional control and a subsequent ground swerve during which the aircraft exited the runway and collided with a runway sign.NTSB LAX01FA027Accident · Serious injuriesField investigationFinal reportGrumman American AA-5A · Gardena, CAThe engine lost power for undetermined reasons.NTSB LAX01FA026Accident · 2 fatalField investigationFinal reportCessna 340A · Julian, CATotal blockage of the instrument static system due to ice.NTSB FTW01FA014Accident · 1 fatalField investigationFinal reportCessna 150L · Rockport, TXthe loss of engine power for undetermined reasons, and the pilot's subsequent failure to maintain control of the airplane during the ensuing forced landing.NTSB FTW01FA013Accident · 1 fatalField investigationFinal reportCessna 210 · Oklahoma City, OKthe pilot's loss of control of the aircraft during initial/takeoff climb. Contributing factors were the night conditions, low ceilings, and the pilot's lack of flight experience in actual instrument meteorological conditions at night.NTSB ANC01FA012Accident · 1 fatalField investigationFinal reportPiper PA-18A · Akhiok, AKThe pilot's inadequate preflight planning/preparation, and inadequate evaluation of weather conditions. Factors in the accident were a tailwind, and a short runway/landing area.NTSB LAX01LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Ramona, CAThe dual student's habit interference, from his previous training in a different type of airplane, that precipitated his improper use of the elevator control during a go-around.NTSB CHI01FA025Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Gaylord, MIThe pilot not maintaining proper glideslope and localizer alignment during the precision instrument approach, the pilot continuing flight below the decision height, the pilot not performing a missed approach, and the pilot not maintaining altitude/clearance…NTSB CHI01FA024Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Sparta, MIThe pilot's failure to maintain proper runway alignment on departure and his failure to maintain clearance from the trees. The pilot's attempted flight into known adverse weather, his lack of instrument experience, the fog, and the trees were contributing…NTSB NYC01LA023Accident · No injuriesLimited investigationFinal reportBombardier CL-600 · New York, NYThe Boeing captain's misjudgment of the distance between his airplane and the CRJ. A factor was the nighttime conditions.NTSB LAX01LA022Accident · Serious injuriesLimited investigationFinal reportBeech 35B33 · Bullhead City, AZThe pilot's inadequate in-flight planning that resulted in fuel starvation and a loss of engine power, and his failure to engage the fuel boost pump in accordance with the owner's manual. A factor was rough terrain in the forced landing area.NTSB LAX01FA024Accident · 2 fatalField investigationFinal reportCessna 152 · Alpine, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB IAD01WA012Accident · 5 fatalForeign investigationCessna P210N · Kampala, UgandaNTSB SEA01LA008Accident · 1 fatalLimited investigationFinal reportWildman Adventurer · Yelm, WAA main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.NTSB SEA01LA007Accident · No injuriesLimited investigationFinal reportBeech N35 · Arlington, WAThe pilot's failure to abort the takeoff upon experiencing directional control difficulties. Factors included the pilot's failure or inability to maintain directional control, and a taxiway sign.NTSB NYC01LA019Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1A · White Plains, NYAn improperly planned approach which resulted in an inadvertent stall.NTSB LAX01FA023Accident · 2 fatalField investigationFinal reportMooney M-20J · Wheaton Springs, CAThe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.NTSB IAD01IA009Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Morristown, NJThe failure of several relays on the roll trim control printed circuit board, which caused an uncommanded aileron trim input.NTSB CHI01LA023Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Minier, ILthe carburetor ice and after takeoff, the unsuitable terrain the pilot encountered during the forced landing. Factors were the carburetor icing conditions and the plowed field condition.NTSB NYC01LA022Accident · Serious injuriesLimited investigationFinal reportHoward Weedhopper · Fordsville, KYAn engine failure for undetermined reasons and the pilot's low altitude flight.NTSB MIA01WA015Accident · 11 fatalForeign investigationPiper PA-34 · Chacabuco, ArgentinaNTSB MIA01LA013Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Knoxville, TNThe pilot's failure to maintain Vs during takeoff/initial climb, which resulted in an inadvertent stall/mush, an uncontrolled descent, and an impact with the ground. Factors in the accident were the pilot's improper preflightplanning/preparation and failure…NTSB MIA01LA011Accident · Serious injuriesLimited investigationFinal reportCamillo Annaloro C A Spcl Quicks · Lucedale, MSThe failure of the pilot to secure a fabric panel during preflight inspection resulting in the panel separating from the aircraft during climb after takeoff, passing through the propeller and damaging wing flap fabric, loss of engine power due to wing flap…NTSB LAX01LA025Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350BA · Kamuela, HIA total loss of engine power due to the failure of the engine manufacturer's repair station personnel to install a circlip during engine overhaul, which resulted in the turbine assembly aft support bearing becoming dislodged and seized on the shaft. A factor…NTSB LAX01LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Half Moon Bay, CAA local windshear condition that exceeded the airplane's climb performance capability during landing approach and resulted in the runway overrun during an attempted go-around.NTSB CHI01LA029Accident · Minor injuriesLimited investigationFinal reportFowler Varieze · Iowa City, IAthe inadequate preflight by the pilot which resulted in the fuel drain remaining partially open. Factors to the accident were the loss of engine power due to fuel starvation, the partially open fuel drain, the unsuitable terrain for landing encountered by the…NTSB ANC01FA011Accident · No injuriesField investigationFinal reportBeech 1900D · Bethel, AKThe flight crew's failure to maintain directional control during the landing roll. A factor associated with the accident was the crew's failure to follow appropriate procedures.NTSB SEA01LA009Accident · No injuriesLimited investigationFinal reportHallett HALLETT-1 · Yelm, WAThe pilot's failure to abort the takeoff when it became questionable as to whether the aircraft would be able to clear an object just off the departure end of the runway, and the pilot's failure to maintain clearance from the object as he attempted to…NTSB NYC01LA020Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Shirley, NYThe pilot's improper in-flight decision to abort the glide toward the airport. A factor was the pilot's failure to comply with the published best glide speed.NTSB NYC01FA021Accident · 3 fatalField investigationFinal reportBeech BE-23-24 · Kingston, OHThe pilot's failure to check both fuel tanks visually during the preflight inspection. A factor in the accident was the dark night.