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 MIA01LA017Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLan inadvertent inflight collision with a bird during cruise flight that resulted in substantial damage to the airplane.NTSB MIA01LA014Accident · Minor injuriesLimited investigationFinal reportCraig R. Merrill Luton Beta · Ridgeland, SCThe pilot's failure to maintain airspeed on final approach resulting in the aircraft settling fast, touching down hard, and colliding with an embankment on the side of the runway, where it came to rest inverted.NTSB MIA01LA012Accident · No injuriesLimited investigationFinal reportCessna 150L · Leesburg, FLThe failure of the pilot of N331DM to maintain a proper visual lookout and ensure adequate clearance, which resulted in a collision with N11938. A factor in the accident was the failure of each pilot to communicate with the other.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB LAX01LA020Accident · 1 fatalLimited investigationFinal reportRyan ST3KR · Georgetown, CAThe airplane's encounter with a strong updraft at the end of the runway that induced an increase in the wing's angle of attack to the critical point, which resulted in an inadvertent stall and spin.NTSB IAD01LA008Accident · Minor injuriesLimited investigationFinal reportConn Sonerai II · Manassas, VAFuel starvation of the engine, caused by the fracturing of the fuel pump switches during a turbulence encounter.NTSB IAD01LA007Accident · No injuriesLimited investigationFinal reportCessna 140 · Mcclure, PAThe loss of engine power over unsuitable terrain due to fuel starvation from a fuel strainer blocked with sealant particles.NTSB CHI01LA022Accident · Minor injuriesLimited investigationFinal reportBollinger BD-4 · Hedrick, IAthe pilot not obtaining/maintaining clearance from the fence. A factors was fence.NTSB CHI01LA021Accident · No injuriesLimited investigationFinal reportBeech A36 · Quincy, ILthe evasive maneuver not possible by the pilot and the deer on the runway. A factor was the dark night.NTSB CHI01LA020Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Pulaski, WIthe evasive maneuver initiated by the pilot. Factors were the presence of the skydiver on the runway, and the pilot's selection of a closed runway.NTSB CHI01LA019Accident · No injuriesLimited investigationFinal reportZenair CH2000 · Springfield, ILthe loose carburetor heat control clamp bolt and carburetor heat not available to the pilot. Factors were the low altitude, the carburetor icing conditions, the fence and the security gate.NTSB NYC01WA051Accident · 1 fatalForeign investigationCessna T303 · Dossenheim, GermanyNTSB IAD01FA006Accident · No injuriesField investigationFinal reportBritish Aerospace Jetstream 3201 · Dulles, VAThe manufacturer's lack of dimensional inspection and repair requirements for the gearbox forward and aft diaphragm, which caused the bull gear to shift and resulted in an uncontained separation of the bull gear during flightNTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA028Accident · No injuriesLimited investigationFinal reportPiper PT-46 · Eden Prairie, MNthe pilot misjudging the landing flare, and his failure to recover from the bounced landing.NTSB NYC01LA025Accident · No injuriesLimited investigationFinal reportCessna 172M · Camp Springs, MDThe pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.NTSB LAX01LA019Accident · Serious injuriesLimited investigationFinal reportBeech 300 · Concord, CAthe pilot's delayed decision to abort the takeoff and his failure to utilize the propeller's reverse pitch function.NTSB FTW01LA012Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Stanton, TXThe failure of the pilot to maintain clearance with the power lines, while maneuvering during an aerial application flight.NTSB CHI01LA018Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · New Ulm, MNThe engine failure for undetermined reasons, the pilot not attaining proper runway alignment, and the misjudged flare by the pilot. A factor was the runway light.NTSB CHI01FA017Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Homer, NEThe inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.NTSB MIA01LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jesup, GAA total failure of the wheel braking system due to the pilot's improper use of braking in downwind, downhill conditions, resulting in overheated brakes, and subsequent encounter with a downslope and terrain collision.NTSB FTW01LA011Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Littlefield, TXthe pilot's failure to maintain clearance with a guy wire while maneuvering during an aerial application flight.NTSB SEA01LA006Accident · No injuriesLimited investigationFinal reportCessna 185F · Driggs, IDThe pilot's failure to maintain directional control. Factors include soft terrain adjacent to the runway.NTSB MIA01LA007Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Dellwood, FLthe pilot's failure to clear the area, and his attempted takeoff while the helicopter's right skid was entangled with vines, which resulted in inadvertent dynamic rollover and substantial damage to the aircraft.NTSB MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…NTSB LAX01FA018Accident · No injuriesField investigationFinal reportBeech C90 · Van Nuys, CAThe failure of the pilot of the other airplane to correctly set a new transponder code and an anomaly in ATC software that precluded the controller from manually overriding the resulting inhibition of displayed data. Factors in the accident were impaired…NTSB IAD01WA005Accident · Serious injuriesForeign investigationCessna 414 · Kiel-Holtenau, GermanyNTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.NTSB CHI01IA016Incident · No injuriesIncident investigationFinal reportBoeing B-727-61 · Wood Dale, ILInadequate overhaul of the flap segment that allowed for corrosion and debonding that resulted in the flap segment departing the airplane during the approach. Factors relating to this incident were insufficient information provided to the overhaul facility by…NTSB NYC01LA015Accident · Serious injuriesLimited investigationFinal reportMoore Starduster SA-300 · Erwinna, PAA total loss of engine power during initial climb for undetermined reasons.NTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.NTSB LAX01FA014Accident · 2 fatalField investigationFinal reportBeech 35-33 · Monterey, CAThe pilot's inadequate in-flight planning/decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain control of the airplane. Contributing factors were low ceiling, spatial disorientation and lack of…NTSB IAD01LA004Accident · No injuriesLimited investigationFinal reportYakovlev 52 · Berryville, VAThe pilot's improper flare, which resulted in a hard landing and separation of the nose landing gear.NTSB DEN01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Jensen, UTan undershoot due to misjudging distance/altitude during an emergency landing. Factors were: inadequate preflight, failure to refuel, fuel exhaustion, operating with an inoperative fuel gauge, and failure to attain a proper glide path during approach.NTSB CHI01LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tecumseh, MIThe pilot was unable to rotate the aircraft during takeoff for undetermined reasons. A factor associated with the accident was the soft terrain, which the airplane encountered during the aborted takeoff.NTSB ATL01FA008Accident · 1 fatalField investigationFinal reportPiper PA-32RT · Selmer, TNThe pilots inadequate preflight planning and preparation, that resulted in exceeding the designed weight and balance of the airplane. Factors were the pilot's use of inappropriate medications and the collision with trees.NTSB ANC01LA008Accident · Minor injuriesLimited investigationFinal reportWeste Avid · Chugiak, AKA total loss of engine power due to a piston failure. Factors in the accident were an out-of-rig flight control system, an inadvertent stall, and no suitable terrain for a forced landing.NTSB ANC01IA007Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Anchorage, AKRupture and disintegration of main landing gear tires during the takeoff roll, and subsequent damage to the right main gear hydraulic brake system.NTSB NYC01LA018Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ridgeway, VAThe pilot's failure to maintain proper runway alignment during the landing roll. A factor in this accident was a slight bend in the runway.NTSB NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.NTSB NYC01LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHThe pilot's failure to maintain directional control while landing with a crosswind. Factors in the accident were the pilot's lack of familiarity in the make and model airplane, and the crosswind conditions.NTSB MIA01LA005Accident · Serious injuriesLimited investigationFinal reportArthur P. Matthews Acro Sport II · Huntersville, NCthe pilot's misjudgment of the distance/speed and failure to attain the proper touchdown point or affect a timely go-around which resulted in the aircraft overrunning the runway and incurring substantial damage when it ran into a streambed.NTSB MIA01FA004Accident · 2 fatalField investigationFinal reportRobinson R-22 · Pembroke Pines, FLThe pilot's failure to maintain rotor rpm and the proper rate of descent during a forced landing/autorotation resulting in an in-flight collision with terrain. Contributing to the accident was a loss of engine power due to the failure of the No. 3 exhaust…NTSB LAX01LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sedona, AZThe pilot's inadequate compensation for wind conditions while on short final landing approach. A factor was the unfavorable wind condition.NTSB LAX01LA013Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grand Canyon, AZThe pilot's in-flight loss of control during liftoff due to his improper planning and decisions. Related factors were the high density altitude and helicopter weight condition, and the lack of a suitable takeoff area.NTSB FTW01RA008Accident · 6 fatalForeign investigationCessna 320E · Ensenada, MexicoNTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB CHI01LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Manhattan, KSthe inadequate soft field takeoff procedure by the pilot and his failure to abort the takeoff. Factors were the high grass on the runway, the pilots disregard for the runway conditions, his lack of total experience in the aircraft, the trees, and the pilots…NTSB ATL01LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Homer, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB SEA01WA005Accident · 3 fatalForeign investigationPiper PA 24-250 · Kelowna, Canada