NTSB investigations, 2001
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\") = 2001 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") = 2001 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 LAX01LA205Accident · No injuriesLimited investigationFinal reportCessna 337G · Temecula, CAThe pilot's intentional flight into adverse weather while operating under visual flight rules, his failure to maintain a cruising altitude sufficient to remain clear of power transmission wires, and his failure to maintain a visual lookout sufficient to see…NTSB LAX01LA193Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Pauma Valley, CAThe pilot's intentional flight into instrument meteorological conditions and failure to maintain clearance from terrain during an approach for landing under visual flight rules.NTSB FTW01LA132Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Fentress, TXthe King Air pilot's inadequate in-flight planning/decision in that he failed to remain in the agreed on formation position, resulting in one of his skydiver's contacting the propeller of the de Havilland airplane. A contributing factor was the lack of total…NTSB FTW01LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Hondo, TXthe pilot's inadequate preflight of the airplane, which resulted in a loss of engine power in cruise flight due to water in the fuel. A contributing factor was the soft terrain encountered during the forced landing.NTSB DEN01LA102Accident · No injuriesLimited investigationFinal reportCessna T207A · Kanab, UTthe pilot's inadequate fuel consumption planning, and the subsequent fuel starvation, which resulted in a loss of engine power.NTSB CHI01LA149Accident · 1 fatalLimited investigationFinal reportGeertz Zenith CH 200 · Kankakee, ILThe loss of control on initial climbout for undetermined reasons.NTSB CHI01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Patriot, INthe inadequate rotation speed and compensation for wind conditions by the pilot. Contributing factors were the crosswind and gust.NTSB CHI01LA147Accident · 1 fatalLimited investigationFinal reportCessna 150H · Protem, MOThe overload of the flap control cable for undetermined reasons resulting in aircraft control not being possible. The trees were a factor.NTSB FTW01FA129Accident · 1 fatalField investigationFinal reportCessna 150 · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.NTSB ATL01LA061Accident · No injuriesLimited investigationFinal reportConrad Menzel SA-300 Starduster · Jackson, MSThe pilot failure to maintain directional control during a crosswind landing.NTSB WAS01WA009Accident · Serious injuriesForeign investigationBell 206L-1 · Rocafuerte, EcuadorNTSB NYC01IA134Incident · No injuriesIncident investigationFinal reportBoeing 727-233 · Harrisburg, PAThe inadvertent misrouting of a wire harness by maintenance personnel, which resulted in chafing to a hydraulic line and electrical wire, and subsequent fire.NTSB LAX01LA192Accident · No injuriesLimited investigationFinal reportCessna 150H · Mariposa, CAThe pilot's failure to properly refuel the aircraft which resulted in departure with an inadequate quantity of fuel onboard. A factor in the accident was the pilot's inadequate preflight preparation and planning, which failed to provide an adequate fuel…NTSB FTW01LA128Accident · 2 fatalLimited investigationFinal reportBlucher KR-2S · Wichita Falls, TXthe pilot's failure to maintain aircraft control following a loss of engine power while maneuvering, which resulted in an inadvertent stall/spin. Contributing factors to the accident were the loss of engine power for undetermined reasons, and the pilot's lack…NTSB DEN01LA104Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West Jordan, UTthe pilot inadvertently flaring the airplane too high above the ground, resulting in a hard landing that sheared a bolt in the tail wheel assembly. This rendered directional control impossible and induced an uncontrolled ground loop. A contributing factor was…NTSB SEA01LA104Accident · No injuriesLimited investigationFinal reportCurtis Lionheart · Bremerton, WAthe pilot's failure to ensure the aircraft's longitudinal axis was aligned with the runway prior to touchdown, and his failure to maintain directional control during the landing roll. Factors include landing with a tailwind, and the pilot's lack of recent…NTSB LAX01LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Cottonwood, AZthe student's inadequate compensation for the gusty crosswind conditions and the subsequent loss of aircraft control during landing roll. The flight instructor’s inadequate supervision and his inadequate remedial action is also causal. Contributing factors…NTSB LAX01LA190Accident · No injuriesLimited investigationFinal reportRobinson R22B · Murietta, CAThe solo student's improper use of the flight controls that resulted in a dynamic rollover during the attempted takeoff.NTSB IAD01WA060Accident · 2 fatalForeign investigationBeech BE-36 · Berlin, GermanyNTSB DEN01FA105Accident · 2 fatalField investigationFinal reportSchempp-Hirth Nimbus-3DM · Alamogordo, NMThe flight crew's inadequate in-flight planning to fly over the mesa with insufficient altitude. A contributing factor was the downdraft weather conditionNTSB SEA01LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Sunriver, ORThe pilot's failure to maintain clearance from trees during initial climb. Trees were a factor.NTSB FTW01FA127Accident · No injuriesField investigationFinal reportFokker F28 Mk 0100 · DFW Airport, TXA forging fold that was introduced during the manufacture of the right main landing, which resulted in a fatigue crack in the right main landing gear cylinder, and its subsequent failure during landing.NTSB ENG01RA001Incident · No injuriesForeign investigationSaab-Scania Saab 340 · Coonamble, NSW, AustraliaNTSB SEA01LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-18-105 Special · Wilbur, WAA collision with terrain for undetermined reasons.NTSB NYC01FA128Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Danvers, MAThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, low ceiling, reduced visibility, and the pilot's decision to attempt a visual flight rules flight in marginal weather conditions.NTSB MIA01IA144Incident · No injuriesIncident investigationFinal reportGrumman G-73 · Fort Lauderdale, FLThe improper review of component records by company maintenance personnel of returned landing gear components from a laboratory for magnaflux and x-ray. This resulted in unserviceable components being tagged as serviceable, installation of unserviceable parts…NTSB IAD01LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-310 · Uniontown, OHFuel exhaustion due to the pilot's failure to perform fuel calculations. A factor was the inboard fuel tank probes not being within the manufacturer's resistance limits, which resulted in inaccurate fuel gauges.NTSB FTW01LA125Accident · 2 fatalLimited investigationFinal reportGideon Wittman Tailwind W8 · Manvel, TXthe flight instructor's failure to maintain control of the airplane during a touch-and-go landing, for an undetermined reason.NTSB CHI01LA145Accident · 1 fatalLimited investigationFinal reportBell Helicopter 407 · Schoolcraft, MIThe pilot rated passenger failed to maintain clearance with the rotor blades as he exited the helicopter.NTSB CHI01LA140Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not maintaining directional control during the reported loss of number one engine power during initial climb and the pilot not following the airplane emergency procedure's corrective action for engine failure after lift-off, and the inadvertent…NTSB SEA01WA099Accident · 10 fatalForeign investigationCessna 172P · Kuwana Mie Pre., JapanNTSB SEA01LA103Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Brush Prairie, WAThe first pilot's failure to maintain aircraft control during a high-speed taxi maneuver. Tall grass adjacent to the runway was a factor.NTSB NYC01WA129Accident · No injuriesForeign investigationPiper PA-28 · Weston, IrelandNTSB MIA01WA179Accident · No injuriesForeign investigationCessna 402 · Walker Cay, BahamasNTSB IAD01LA058Accident · No injuriesLimited investigationFinal reportBeech 55 · West Chester, PAThe partial blockage of the pitot/static system, which led to an inaccurate airspeed indication, and resulted in an aborted takeoff and runway overrun. A factor was the wet runway.NTSB FTW01LA126Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Tulsa, OKthe dual student pilot's failure to maintain clearance from the hangar while taxing.NTSB DEN01LA101Accident · No injuriesLimited investigationFinal reportGarrett Starduster TOO SA300 · Woodrow, COa precautionary landing on unsuitable terrain which was rough and uneven. Factors were deteriorating weather in the form of freezing rain, snow, and decreasing visibility.NTSB DCA01WA046Accident · Serious injuriesForeign investigationBoeing B-747-400 · Guam (Pacific Ocean)NTSB ANC01LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Anchorage, AKThe pilot's selection of an unsuitable taxi area during taxi. A factor associated with the accident was a tree.NTSB LAX01LA189Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Reno, NVFailure of the left main landing gear axle due to an improper weld repair.NTSB LAX01LA188Accident · No injuriesLimited investigationFinal reportWright Avid Flyer · Show Low, AZthe pilot's failure to maintain control of the airplane during a go-around, which resulted in an in-flight collision with terrain and a nose down. A contributing factor was the turbulence.NTSB LAX01LA182Accident · No injuriesLimited investigationFinal reportCessna 182E · Fallon, NVThe pilot's failure to maintain clearance with a road sign during an emergency landing to a road. Contributing factors were the smoke created from a bird nest in the engine compartment, and the pilot's diverted attention due to an approaching car on the road.NTSB FTW01LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Fort Worth, TXthe inadvertent ground loop during the landing roll. A contributing factor was the gusty crosswind.NTSB CHI01LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Roscommon, MIThe failure of the pilot to maintain clearance from the tree line. Factors to the accident were the tailwind, the aircraft being near gross weight, the high density altitude, the rough runway condition, and the tree line. An additional factor to the accident…NTSB ATL01LA058Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Brooksville, FLThe fatigue failure of the left main landing gear strut that resulted in collapse of the landing gear.NTSB SEA01LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Rogersburg, WAThe pilot's failure to maintain aircraft control while on final approach for landing. A tailwind was a factor.NTSB LAX01LA187Accident · Minor injuriesLimited investigationFinal reportBennett Glastar · Grass Valley, CAThe pilot's failure to arrest the excessive descent rate. A contributing factor was the gusty wind conditions.NTSB LAX01FA186Accident · 1 fatalField investigationFinal reportBeech M35 · North Las Vegas, NVThe pilot/owner's failure to correctly install the oil filter, which resulted in oil exhaustion and a loss of engine power. Also causal was his attempt to modify the design of the oil filter element adapter by breaking the bond between the base and the…NTSB CHI01LA316Accident · No injuriesLimited investigationFinal reportCessna 172R · Alton, ILThe misjudged flare by the pilot.NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.