NTSB investigations, 1968, 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\") = 1968
    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.

NTSB CHI69D0119Accident · No injuriesClosedTaylorcraft BC12-D · Reedsburg, WIJun 2, 1968 · N96105 · Substantial damageNTSB CHI69D0015Accident · No injuriesClosedStinson 108-2 · Burkhardt, WIMay 31, 1968 · N9472K · Substantial damageNTSB CHI69D0029Accident · No injuriesClosedMooney M20A · Kenosha, WIMay 22, 1968 · N8390E · Substantial damageNTSB CHI68A0096Accident · 1 fatalClosedBeech D18 · Marshfield, WIMay 15, 1968 · N1977D · DestroyedNTSB CHI69D0040Accident · No injuriesClosedBeech T-34A · Milwaukee, WIMay 14, 1968 · N2969C · Substantial damageNTSB CHI69D0037Accident · No injuriesClosedBeech C35 · Delavan, WIMay 12, 1968 · N1920D · Substantial damageNTSB CHI69D0012Accident · Minor injuriesClosedCessna 172 · Walworth, WIMay 12, 1968 · N8356X · DestroyedNTSB CHI68F0753Accident · No injuriesClosedEnstrom F-28 · Milwaukee, WIMay 10, 1968 · N4462 · Substantial damageNTSB CHI68D0752Accident · No injuriesClosedPiper PA-22 · Stoughton, WIMay 8, 1968 · N6159D · Substantial damageNTSB CHI68D0754Accident · No injuriesClosedCessna 337B · Genoa City, WIMay 7, 1968 · N54385 · Substantial damageNTSB CHI68D0724Accident · No injuriesClosedPiper PA-24 · Milwaukee, WIApr 28, 1968 · N5078P · Substantial damageNTSB MKC68F0580Accident · Serious injuriesClosedStinson 108-2 · Menomonie, WIApr 27, 1968 · N973D · DestroyedNTSB CHI69D0021Accident · Minor injuriesClosedPiper PA-28 · Juneau, WIApr 21, 1968 · N4283J · Substantial damageNTSB CHI68A0094Accident · 2 fatalClosedAeronca 7AC · Ladysmith, WIApr 21, 1968 · N85137 · DestroyedNTSB CHI68A0090Accident · 1 fatalClosedCessna 170B · Waukesha, WIApr 17, 1968 · N4304B · DestroyedNTSB CHI68D0696Incident · No injuriesClosedCessna 185C · Grafton, WIApr 16, 1968 · N2674Z · Substantial damageNTSB CHI69F0271Accident · No injuriesClosedCessna 337 · Milwaukee, WIApr 11, 1968 · N2363S · Substantial damageNTSB CHI68D0664Accident · No injuriesClosedCessna 150 · Pulaski, WIMar 21, 1968 · N2213J · Substantial damageNTSB CHI68A0080Accident · 1 fatalClosedAeronca 7AC · Franklin, WIMar 7, 1968 · N85100 · DestroyedNTSB CHI68F0692Accident · No injuriesClosedMooney M20F · Oshkosh, WIMar 5, 1968 · N2907L · Substantial damageNTSB CHI68D0360Accident · No injuriesClosedPiper PA-22 · Platteville, WIFeb 24, 1968 · N3820P · Substantial damageNTSB CHI68F0618Accident · No injuriesClosedPiper PA-24 · West Bend, WIFeb 13, 1968 · N7523P · Substantial damageNTSB CHI68F0586Accident · No injuriesClosedCessna 210B · Sauk City, WIFeb 5, 1968 · N9627X · Substantial damageNTSB CHI68D0584Accident · Minor injuriesClosedBeech A23 · Milwaukee, WIFeb 5, 1968 · N4733J · DestroyedNTSB CHI68F0612Accident · Minor injuriesClosedCessna 177 · Walworth, WIFeb 4, 1968 · N3361T · Substantial damageNTSB CHI68F0583Accident · No injuriesClosedCessna 177 · Middleton, WIFeb 3, 1968 · N2893X · Substantial damageNTSB CHI68D0580Accident · No injuriesClosedPiper PA-22 · Platteville, WIFeb 3, 1968 · N4990Z · Substantial damageNTSB CHI68D0579Accident · No injuriesClosedCessna 172 · Brussels, WIJan 30, 1968 · N5520T · Substantial damageNTSB CHI68A0063Accident · 1 fatalClosedPiper J3C-65 · Beloit, WIJan 21, 1968 · N33495 · DestroyedNTSB CHI68F0594Accident · No injuriesClosedPiper PA-24 · West Bend, WIJan 18, 1968 · N8042P · Substantial damageNTSB CHI68D0544Accident · No injuriesClosedCessna 150 · Superior, WIJan 13, 1968 · N2707S · Substantial damage