NTSB investigations, 2000
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 NYC00LA189Accident · No injuriesLimited investigationFinal reportCessna 150 · Freemont, DEThe pilot's failure to maintain altitude/clearance and delayed power application while attempting to release a banner from the airplane.NTSB MIA00WA211Accident · 5 fatalForeign investigationCessna 310N · Rio Lujan, ArgentinaNTSB MIA00LA213Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belleview, FLthe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB MIA00LA207Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Boone, NCThe failure of the inter-cooler duct connecting the inter-cooler to the engine due to inadequate attachment of the inter-cooler to the aircraft which resulted in loss of turbocharger air overboard and loss of engine power and damage to the aircraft during a…NTSB LAX00LA254Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6F · Grass Valley, CAfailure of the pilot to maintain directional control during the landing roll resulting in a collision with terrain.NTSB DEN00LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Logan, UTin-flight collision with a jacket, which blew out of the helicopter because the left passenger door was not properly secured prior to takeoff. A contributing factor was the pilot's failure to ensure the door was properly closed prior to takeoff.NTSB CHI00LA189Accident · No injuriesLimited investigationFinal reportStaudacher S-300D2 · Kenosha, WIThe fatigue failure of the rod end bearing and the separation of the aileron. A factor was the inadequate design change by the aircraft designer.NTSB CHI00LA181Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Champion, NEthe undetermined uncontrolled descent.NTSB ANC00LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Anaktuvuk Pass, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were a fuel drum, and a tailwind.NTSB SEA00LA125Accident · No injuriesLimited investigationFinal reportCessna 172I · Sandy, ORThe pilot's failure to attain the proper touchdown point for landing, and his failure to go around from the improperly executed approach. Factors included the pilot's failure to attain the proper glidepath on the approach, a short landing runway, and…NTSB NYC00LA193Accident · No injuriesLimited investigationFinal reportCessna U206G · North Haven, METhe pilot's failure to perform a go-around. Factors related to the accident were the pilot's lack of total flight experience in make and model, and the short landing area.NTSB NYC00LA190Accident · No injuriesLimited investigationFinal reportSpartan 7W · Jefferson, OHThe overload failure of the left main gear strut housing.NTSB NYC00LA187Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wildwood, NJan improper flare by the pilot which induced an overload failure on the left side landing gear bolts. Factors were the corrosion on the bolts, and the failure of the operator to change the u-bolt in accordance with the manufacturer's recommendations.NTSB MIA00LA216Accident · No injuriesLimited investigationFinal reportAviat Husky · Dayton, TNThe pilot's failure to maintain directional control of the airplane during landing flare into a crosswind, resulting in a runway excursion off the runway edge and collision of the wingtip with the terrain.NTSB LAX00LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakland, CAfailure of the instructor to adequately supervise the student, resulting in a loss of directional control.NTSB LAX00LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZThe student pilot's failure to maintain directional control of the airplane during landing.NTSB DEN00LA123Accident · No injuriesLimited investigationFinal reportBeech G18S · Taos, NMFailure of the pilot receiving instruction to maintain directional control. Factors were a gusty crosswind, inadequate supervision by the flight instructor, and the runway light.NTSB CHI00FA184Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Quincy, ILThe pilots failure to maintain control of the aircraft and his continued flight into adverse weather. Factors were the fog, and the crops.NTSB LAX00LA258Accident · No injuriesLimited investigationFinal reportCessna 205 · Tacna, AZThe piston and rings in cylinder No. 1 failed resulting in a total loss of engine power. The pilot made a forced landing on a road and the airplane's wing collided with a road sign.NTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA182Accident · No injuriesLimited investigationFinal reportCessna 172R · Athens, MIthe failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…NTSB ANC00IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Deadhorse, AKAn in-flight fracture of the engine crankshaft propeller flange. A factor associated with the accident was the manufacturer's inadequate quality control standards.NTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.NTSB MIA00LA202Accident · 1 fatalLimited investigationFinal reportCessna A188B · Inverness, MSThe failure of the pilot to maintain airspeed while reversing course during an aerial application flight resulting in the aircraft stalling, descending, impacting a tree, and crashing to the ground.NTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…NTSB LAX00LA250Accident · Serious injuriesLimited investigationFinal reportThorp T211 · Grass Valley, CAthe pilot encountered a mountain wave at an altitude too low to maintain clearance from trees.NTSB FTW00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, TXThe pilot's improper flare, which resulted in a hard landing.NTSB CHI00LA192Accident · No injuriesLimited investigationFinal reportCreed Lancair 235 · Hot Springs, SDthe failure of the pilot to select the correct runway for takeoff. Factors to the accident were the inadequate preflight planning/preparation, the aborted takeoff not performed, and the tailwind.NTSB CHI00LA188Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20L · Gregory, MIthe control stick movement being restricted by the pilot's seat-type parachute and the excessive descent rate and airspeed during landing. A factor to the accident was the pilot's lack of familiarity with the aircraft.NTSB ANC00FA082Accident · 1 fatalField investigationFinal reportCessna 172S · Whittier, AKSuicide.NTSB SEA00LA126Accident · No injuriesLimited investigationFinal reportCessna 120 · Toston, MTThe pilot's failure to maintain sufficient altitude to avoid contact with the ground. Contributing factors were the downdraft conditions and the fence post.NTSB SEA00LA123Accident · No injuriesLimited investigationFinal reportCessna 210E · Pocatello, IDImproper landing flare resulting in a hard landing. Factors include dark night environmental conditions and lack of recent experience for night landings.NTSB SEA00LA122Accident · No injuriesLimited investigationFinal reportCessna 150L · Nampa, IDThe pilot's improper use of the mixture control.NTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.NTSB NYC00FA183Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to maintain airspeed, resulting in an inadvertent stall. Factors were the entanglement of the tow rope with the rudder horn, restricted rudder movement, the pilot's lack of total experience in the type of operation, and no stall warning…NTSB MIA00LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ocracoke, NCThe pilot's failure to compensate with rudder control for engine torque and 'p' factor during a go-around resulting in the aircraft drifting to the left, colliding with brush, and spinning around coming to rest in the brush.NTSB MIA00LA196Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Selma, ALThe improper installation of the engine front crankshaft seal by maintenance personnel resulting in the seal separating, total loss of engine oil, failure of the engine due to oil starvation, and a collision with trees while making a forced landing on…NTSB LAX00LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · King City, CAThe loss of engine power for undetermined reasons.NTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.NTSB FTW00LA192Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Brownfield, TXThe loss of engine power due to the blocked engine intake, which resulted from ingesting birds. Factors were the lack of suitable terrain for the forced landing and the pilot's intentional ground loop in an attempt to avoid a ditch.NTSB DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.NTSB DEN00LA121Accident · No injuriesLimited investigationFinal reportCessna 172P · Price, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were strong and gusty winds.NTSB SEA00LA121Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · West Linn, ORImproper maintenance (excessive/improper sealant application) by an unknown person, and subsequent fracture of the spur adapter gearshaft resulting in a total loss of engine power. Factors included foreign material/substance in the engine oil, a blocked oil…NTSB SEA00LA120Accident · No injuriesLimited investigationFinal reportCessna U206B · Yellow Pine, IDThe locknut was not secured and backed off the bolt. An improper maintenance installation was a factor.NTSB NYC00LA184Accident · 2 fatalLimited investigationFinal reportHartzell Rans S-12 · Strattanville, PAThe pilot's failure to maintain adequate airspeed during low level maneuvering, which resulted in an inadvertent stall/spin.NTSB NYC00LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson Center, PAA seized left brake as reported by the pilot.NTSB NYC00LA180Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Bally, PAThe pilot's failure to maintain control of the airplane after an aborted takeoff.NTSB MIA00TA200Accident · No injuriesFinal reportHughes 369D · Destin, FLimproper maintenance inspection of the tail rotor by maintenance personnel and improper preflight inspection of the tail rotor by the pilot, which resulted in worn elastomeric bearings being continued in service, resulting in failure of the tail rotor…NTSB MIA00LA206Accident · No injuriesLimited investigationFinal reportBoeing 737-49R · Orlando, FLThe captain's failure to stop the aircraft when given a stop signal by the ground marshaller and his failure to turn the aircraft when given a turn signal by the ground marshaller as he taxied into the gate resulting in the aircraft's left wing colliding with…NTSB MIA00LA205Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Lake Wales, FLThe pilot's inadequate visual lookout while maneuvering to avoid a flock of birds shortly after takeoff, resulting in the aircraft colliding with a wire. A factor in the accident was the pilot's fatigue after having worked everyday for the previous 3 weeks.