NTSB investigations, 1993, WI
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 per year
| 1964 | 70 |
|---|---|
| 1965 | 75 |
| 1966 | 88 |
| 1967 | 99 |
| 1968 | 81 |
| 1969 | 93 |
| 1970 | 87 |
| 1971 | 65 |
| 1972 | 74 |
| 1973 | 77 |
| 1974 | 81 |
| 1975 | 69 |
| 1976 | 55 |
| 1977 | 75 |
| 1978 | 90 |
| 1979 | 89 |
| 1980 | 62 |
| 1981 | 69 |
| 1982 | 54 |
| 1983 | 60 |
| 1984 | 64 |
| 1985 | 59 |
| 1986 | 55 |
| 1987 | 48 |
| 1988 | 47 |
| 1989 | 56 |
| 1990 | 47 |
| 1991 | 46 |
| 1992 | 39 |
| 1993 | 55 |
| 1994 | 41 |
| 1995 | 41 |
| 1996 | 35 |
| 1997 | 33 |
| 1998 | 44 |
| 1999 | 44 |
| 2000 | 34 |
| 2001 | 46 |
| 2002 | 37 |
| 2003 | 32 |
| 2004 | 37 |
| 2005 | 38 |
| 2006 | 21 |
| 2007 | 32 |
| 2008 | 40 |
| 2009 | 23 |
| 2010 | 26 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 18 |
| 2014 | 22 |
| 2015 | 30 |
| 2016 | 28 |
| 2017 | 25 |
| 2018 | 26 |
| 2019 | 19 |
| 2020 | 14 |
| 2021 | 25 |
| 2022 | 23 |
| 2023 | 25 |
| 2024 | 24 |
| 2025 | 24 |
| 2026 | 20 |
Where
Open the mapLatest cases
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\") = 1993
AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
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") = 1993 AND c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' 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 CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.NTSB CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.NTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).NTSB CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…NTSB CHI94LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Byron, WIthe pilot's inaccurate fuel consumption calculations which resulted in his not refueling during the flight. A factor related to the accident was the pilot's failure to maintain proper airspeed during the forced landing.NTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.NTSB CHI94FA001Accident · 1 fatalField investigationFinal reportBeech G35 · Webster, WIIn-flight breakup of the airplane for an undetermined reason.NTSB CHI93LA379Accident · No injuriesLimited investigationFinal reportCessna 150M · Burlington, WIthe improper fuel calculations by the pilot-in-command. Factors were the pilot-in-command's not refueling and uphill terrain.NTSB CHI93LA371Accident · No injuriesLimited investigationFinal reportPiper PA-60-601 · Lone Rock, WIInadequate maintenance and excessive airspeed during the landing approach.NTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.NTSB CHI93LA366Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Madison, WIthe loose fuel selector handle/valve which resulted in an inability to properly switch fuel tanks.NTSB CHI93LA349Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Delevan, WIthe excessive use of brakes and rudder by the pilot-in-command. A factor related to the accident was the pilot-in-command's lack of total experience in this type of aircraft.NTSB CHI93DEP05Accident · Minor injuriesFinal reportBell 47-G5 · Fulton, WIthe failure (fracture) of the number one cylinder intake valve retainer (keeper).NTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.NTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).NTSB CHI93DEP03Accident · No injuriesFinal reportKit Fox IV · Green Bay, WIthe improper modification of the fuel system by the pilot-in-command. A factor was bockage of the fuel system screen.NTSB CHI93FA296Accident · Serious injuriesField investigationFinal reportGrumman G58A · Oshkosh, WIThe pilot-in-command's inadvertent use of the mixture resulting in a lean mixture.NTSB CHI93LA295Accident · Minor injuriesLimited investigationFinal reportGardner SEA RAY · Oshkosh, WIThe pilot in command's not maintaining proper climb rate. A factor was the abrupt control interference by the passenger.NTSB CHI93LA294Accident · No injuriesLimited investigationFinal reportNorth American F-51 · Fond Du Lac, WIthe pilot-in-command of the F-51's diverted attention and failure to maintain a visual outlook.NTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.NTSB CHI93LA288Accident · No injuriesLimited investigationFinal reportMurphy Rebel · Pickett, WIThe pilot's inadequate preflight planning which resulted in fuel exhaustion. The lack of suitable terrain for a forced landing was a factor in the accident.NTSB CHI93DEP02Accident · 1 fatalFinal reportStoeckler RV-4 · Lake Delton, WIthe pilot-in-command's failure to maintain proper altitude. A factor was trees.NTSB CHI93LA268Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Elderon, WIThe pilot's failure to refuel the helicopter.NTSB CHI93LA269Accident · 1 fatalLimited investigationFinal reportBeech A23 · Boyceville, WIthe failure of the pilot to attain the proper touchdown point, and his failure to perform a go-around.NTSB CHI93LA258Accident · No injuriesLimited investigationFinal reportMaule M4 · Tomahawk, WIthe pilot's improper recovery from a bounced landing.NTSB CHI93LA253Accident · Minor injuriesLimited investigationFinal reportCessna 210 · West Bend, WIThe inadequate preflight by pilot-in-command. A factor was the rough terrain.NTSB CHI93LA246Accident · No injuriesLimited investigationFinal reportCessna R172K · Middleton, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA237Accident · Serious injuriesLimited investigationFinal reportDaniel Squire HI-MAX · Omro, WIthe pilot's inadequate preflight planning and preparation. A factor in the accident is the downdraft.NTSB CHI93LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Waukesha, WIThe pilot's failure to maintain airspeed above a stall.NTSB CHI93LA223Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Osceola, WIThe pilot in command's failure to maintain directional control.NTSB CHI93LA224Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Baraboo, WIan encounter with moderate turbulence in the clouds.NTSB CHI93LA210Accident · No injuriesLimited investigationFinal reportBeech B19 · Janesville, WIThe pilot's improper landing flare.NTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA201Accident · 1 fatalLimited investigationFinal reportBell 47G-2A-1 · Phlox, WIWas the pilot in command's failure to maintain aircraft control. A factor to the accident was the inadequate cyclic control.NTSB CHI93FA200Accident · 2 fatalField investigationFinal reportBeech A-36 · Tony, WIthe pilot's decision to continue flight into known adverse weather and exceeded the design strees limits of the airplane. Factors associated with the accident were inadequate preflight planning/preparation, clouds, turbulence, icing conditions, and the lack…NTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.NTSB CHI93DEP01Accident · No injuriesFinal reportBryant Mustang II · Kenosha, WIThe pilot-in-command's not maintaining control of the aircraft.NTSB CHI93LA327Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace ATP · Green Bay, WIthe passenger's loss of footing (miscellaneous).NTSB CHI93LA163Accident · No injuriesLimited investigationFinal reportCessna 150J · Rice Lake, WIThe student pilot's failure to maintain directional control of the airplane.NTSB CHI93FA158Accident · 1 fatalField investigationFinal reportBeech E-18S · Lone Rock, WIwas a pre-mature extension of the landing gear by the pilot which resulted in the inability of the pilot to maintain the minimum descent altitude. Factors related to the accident were the loose cylinder and loss of oil.NTSB CHI93LA155Accident · No injuriesLimited investigationFinal reportMaule M5 · Green Bay, WIThe pilot's failure to maintain control of the airplane.NTSB CHI93LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Oshkosh, WILoss of engine power for an undetermined reason.NTSB CHI93LA164Accident · No injuriesLimited investigationFinal reportGrumman TBM-3E · Spooner, WIThe pilot's failure to maintain directional control.NTSB CHI93LA144Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Mineral Point, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93FAMS3Accident · 2 fatalMissing aircraftFinal reportLake LA-4 · Superior, WIundetermined.NTSB CHI93FA139Accident · 2 fatalField investigationFinal reportCessna 172I · Ettrick, WIAn inflight explosion of a toluene-based fluid inside the airplane's cockpit.NTSB CHI93IA140Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Oshkosh, WIan inoperative engine nacelle anti-ice system, and ice ingestion.NTSB CHI93LA130Accident · No injuriesLimited investigationFinal reportBeech B-55 · Green Bay, WIImproper replacement of the right wing by maintenance personnel which resulted in the vapor return lines being reversed, and the auxiliary tank vent to be disconnected.NTSB CHI93LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Lyons, WIThe pilot's use of an unsuitable runway.