NTSB investigations, 1978, WI
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\") = 1978
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") = 1978 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 CHI78DEP44Accident · No injuriesClosedPiper PA-28 · Gleason, WINTSB CHI78DEP43Accident · Minor injuriesClosedCessna 172 · Arbor Vitae, WINTSB CHI78FEP41Accident · No injuriesClosedPiper PA-32 · Lakewood, WINTSB CHI78DEP42Accident · No injuriesClosedCessna 210M · Mercer, WINTSB CHI78FEP40Accident · No injuriesClosedBeech B-23 · Lacrosse, WINTSB CHI78DER05Accident · No injuriesClosedGrumman AA-5B · Birchwood, WINTSB CHI78DEP39Accident · No injuriesClosedMustang II · East Troy, WINTSB CHI78DEP38Accident · No injuriesClosedPiper PA-18 · Lake Winnebego, WINTSB CHI78FEP37Accident · No injuriesClosedDehavilland DHC-2 · Chippewa Falls, WINTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WINTSB CHI78FA041Accident · 4 fatalClosedCessna T210M · Bloomer, WINTSB CHI78FEP36Accident · Serious injuriesClosedPiper PA-28 · Portage, WINTSB CHI78DEP35Accident · Minor injuriesClosedMustang II · Lancaster, WINTSB CHI78DEP34Accident · Minor injuriesClosedHughes 269 · B1rchwood, WINTSB CHI78DEP32Accident · Minor injuriesClosedCessna 150 · Baileys Harbor, WINTSB CHI78DEP33Accident · No injuriesClosedCessna 185 · Clyman, WINTSB CHI78DER04Accident · No injuriesClosedCessna 150L · Grantsburg, WINTSB CHI78FEP30Accident · No injuriesClosedCessna 172 · Middleton, WINTSB CHI78DEP31Accident · No injuriesClosedCessna 172 · Middleton, WINTSB CHI78FEP29Accident · No injuriesClosedPiper PA-36 · Neenah, WINTSB CHI78DEP27Accident · No injuriesClosedCessna 150 · Black River, WINTSB CHI78FEP28Accident · No injuriesClosedCessna 177RG · Dodgeville, WINTSB CHI78DEP25Accident · No injuriesClosedCessna 152 · Milwaukee, WINTSB CHI78DEP26Accident · No injuriesClosedCessna 150 · Delavan, WINTSB CHI78FEP23Accident · No injuriesClosedGrumman AA1-B · Waukesha, WINTSB CHI78FEP24Accident · No injuriesClosedPiper PA-28 · Lacrosse, WINTSB CHI78FEP22Accident · No injuriesClosedCessna 182E · East Troy, WINTSB CHI78FEP19Accident · No injuriesClosedTaylorcraft BL-65 · Hartford, WINTSB CHI78DEP18Accident · No injuriesClosedCessna 150F · Necedah, WINTSB CHI78FEP21Accident · No injuriesClosedCessna 172H · Fond Du Lac, WINTSB CHI78FEP20Accident · Minor injuriesClosedPiper PA-28R · Pewaukee, WINTSB CHI78DEP16Accident · No injuriesClosedCessna 150 · Kenosha, WINTSB CHI78FEP14Accident · Minor injuriesClosedBell 47-J · Wilmot, WINTSB CHI78DEP12Accident · No injuriesClosedCessna 150L · Sun Prairie, WINTSB CHI78FEP13Accident · No injuriesClosedCessna 150-J · Necedha, WINTSB CHI78FEP13Accident · No injuriesClosedPiper PA-32 · Watertown, WINTSB CHI78FEP11Accident · No injuriesClosedCessna 172L · Waukesha, WINTSB CHI78DER03Accident · No injuriesClosedCessna 150 · Superior, WINTSB CHI78DER02Accident · No injuriesClosedPiper PA-28 · Amery, WINTSB CHI78FA034Accident · 1 fatalClosedPiper PA-28 · Mellen, WI