NTSB investigations, 2000
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 LAX00FA130Accident · 1 fatalField investigationFinal reportBell 212 · Snelling, CAthe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB CHI00LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Festus, MOthe pilot inadvertently retracted the landing gear instead of the flaps during the landing roll.NTSB ANC00LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe pilot's inadvertent stall during an attempted go-around. A factor associated with the accident was the pilot's failure to maintain proper runway alignment.NTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).NTSB LAX00LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · Sacramento, CAThe failure of the pilot to maintain directional control of the aircraft during the takeoff roll. A rough, uneven runway surface was a factor in the accident.NTSB IAD00LA027Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAthe improper entry into the traffic pattern by the pilot of the Piper airplane and the inadequate lookout by the pilots in both airplanes. A factor in the accident was that radio communication was not possible because the Piper was not so equipped, and the…NTSB DEN00LA062Accident · Minor injuriesLimited investigationFinal reportAdams A55S · Los Lunas, NMThe pilot's decision not to deflate the envelope. A factor was the wind gust.NTSB CHI00FA090Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Dighton, KSthe inadvertent stall. Factors relating to this accident were the pilot's inadvertent flight into known adverse weather conditions, the icing conditions, and improper in-flight planning by the pilot.NTSB SEA00WA056Accident · 2 fatalForeign investigationDouglas DC-3C · Ennadai Lake, CanadaNTSB NYC00LA206Accident · Serious injuriesLimited investigationFinal reportBeechcraft 1900D · Plattsburgh, NYThe failure of the upper anchor bracket for the airstair door.NTSB NYC00FA092Accident · Minor injuriesField investigationFinal reportDassault DA-900 · Hyannis, MAThe flightcrew's inadequate coordination and improper weather evaluation. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length and his failure to obtain the proper touch down point on the runway.…NTSB MIA00WA122Accident · 10 fatalForeign investigationde Havilland DHC-6 · Carreto, PanamaNTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.NTSB MIA00LA110Accident · Minor injuriesLimited investigationFinal reportAeronca-Bubeck Irving BUBECK-AERONCA · Merritt Island, FLThe flight instructors inadequate supervision of the dual student resulting in the student pushing forward on the control stick during a bounced landing until the aircraft impacted the runway, bounced, landed hard, and broke the main landing gear.NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB SEA00LA052Accident · No injuriesLimited investigationFinal reportCessna A185-F · Bend, ORThe pilot's failure to adequately compensate for wind conditions.NTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.NTSB LAX00LA128Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Buckeye, AZThe pilot's improper judgment and his failure to maintain clearance from the ground. A factor was the pilot's lack of recent experience.NTSB FTW00LA099Accident · No injuriesLimited investigationFinal reportCessna 402C · San Antonio, TXThe pilot's inadequate handling of the aircraft during the landing flare/touchdown resulting in a hard landing that collapsed the left main landing gear.NTSB DEN00LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Provo, UTThe pilot misjudging the flare. Factors were dark night conditions, and the pilot's lack of recent experience in the type of operation (night landings).NTSB DEN00LA060Accident · No injuriesLimited investigationFinal reportBeech B55 · Ogden, UTInadvertent landing gear retraction by person(s) undetermined. A factor was the inadequate supervision of the flight by the flight instructor.NTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.NTSB LAX00GA114Accident · Minor injuriesFinal reportBell OH-58C · Compton, CAAn undetermined electrical system voltage surge.NTSB MIA00IA104Incident · No injuriesIncident investigationFinal reportBeech 58 · Memphis, TNfailure of the right main landing gear's dynamic brake relay, that resulted in the motor driving the gearbox past prescribed limits, resulting in a bent connecting rod, and failure of the gear to extend.NTSB MIA00FA107Accident · No injuriesField investigationFinal reportCessna 310D · Stuart, FLthe failure of both pilots to maintain an adequate visual lookout, resulting in both airplanes colliding in flight. Contributing to the accident were: 1) inadequate approach/departure control service by ATC approach/departure personnel, and the failure of the…NTSB LAX00IA127Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · San Francisco, CAfailure of the right main landing gear to fully extend for undetermined reasons.NTSB FTW00LA096Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Rayville, LAThe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the dark night light condition.NTSB DEN00LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Rifle, COLoss of engine power for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB SEA00LA051Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Odell, ORThe pilot's failure to maintain sufficient altitude over, or clearance with, a tree. Factors contributing to the occurrence of the accident were the tree and sharply rising terrain. A factor contributing to the severity of the accident was a post-crash fuel…NTSB LAX00TA125Accident · Serious injuriesFinal reportPiper PA-18-150 · Rio Vista, CAfailure of the pilot to maintain clearance from power lines while maneuvering at a low altitude. A factor was glare from the sun.NTSB FTW00LA110Accident · No injuriesLimited investigationFinal reportCessna A188B · Perryton, TXThe pilot's failure to maintain directional control during the takeoff roll. A factor was the crosswind.NTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.NTSB FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.NTSB DEN00LA058Accident · No injuriesLimited investigationFinal reportBeech A23A · Rawlins, WYThe pilot's failure to abort the landing in a timely manner. Factors were the tailwind and high density altitude, resulting in inadequate climb performance.NTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.NTSB LAX00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Vacaville, CAFailure of the pilot to see wires and maintain clearance while flying at a low altitude.NTSB IAD00IA026Incident · No injuriesIncident investigationFinal reportBoeing - Canada DHC-8-102 · Baltimore, MDthe missing elevator stop bumper that resulted in elevator over-travel and damage to the elevator. A factor in the incident was the abrupt release of the elevator control lock in windy conditions.NTSB DEN00LA057Accident · No injuriesLimited investigationFinal reportLearjet 60 · Jackson, WYThe pilot not following the airplane manufacturer's recommended landing procedures for a contaminated runway by landing with a tailwind. Factors were the pilot's inadvertent deactivation of the anti-skid protection, the ice contaminated runway, and the snow…NTSB DEN00LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Belen, NMA loss of engine power due to low cylinder compression from an open exhaust valve, and the pilot's failure to lean the fuel mixture.NTSB SEA00LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Townsend, WAThe pilot's failure to adequately compensate for changing wind conditions during the landing roll in a tailwheel-equipped aircraft. Factors include a variable, shifting wind that changed from a quartering headwind to a quartering tailwind just prior to the…NTSB LAX00LA129Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Diego, CAThe pilot's selection of an inadequate takeoff area which precluded his ability to remain in ground effect until entering translational lift and resulted in his failure to maintain main rotor rpm.NTSB LAX00FA126Accident · 1 fatalField investigationFinal reportCessna 182Q · Fallbrook, CAthe loss of engine power resulting from fuel starvation due to the pilot's inadequate pre-flight inspection, inadequate performance of the pre-takeoff checklist, and failure to ensure that the fuel selector was properly positioned prior to takeoff. Also…NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Neenah, WIthe pilot's inability to flare the airplane during landing and the subsequent loss of directional control due to restricted movement of the control stick. The control stick movement was restricted by the rear seat cushion which was not secured to the…NTSB MIA00LA214Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCThe failure of the pilot to initiate a go-around after the airplane began to porpoise, resulting in a hard landing and structural damage to the airplane.NTSB MIA00LA108Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Athens, GAThe flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.NTSB LAX00FA123Accident · Serious injuriesField investigationFinal reportBoeing 369D · Rough And Ready, CAa loss of engine power due to oil starvation. The oil starvation was due to the seizure and failure of the turbine element oil pump shaft, which was caused by debris from a failed bearing seizing the pump. A factor in the accident was the lack of a suitable…NTSB FTW00LA095Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Midland, TXThe separation of the right main landing gear tire tread which resulted in damage to the right main landing gear mounting structure.NTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.NTSB FTW00FA091Accident · 4 fatalField investigationFinal reportEurocopter BO105S-CBS-5 · Dalhart, TXThe pilot's failure to maintain control of the helicopter as a result of his continued flight into known adverse weather conditions. Factors were the dark night light condition, fog, low ceiling, and the pilot's lack of total instrument flight time.