NTSB investigations, 1981, MN
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\") = 1981
AND c.\"eventStateOrRegion\" = 'MN' 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") = 1981 AND c."eventStateOrRegion" = 'MN' 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 CHI81FER48Accident · No injuriesClosedCessna 172P · Thief River Fa, MNNTSB CHI81FA069Accident · Serious injuriesClosedRockwell 680V · Minneapolis, MNNTSB CHI81DER47Accident · No injuriesClosedBell 47G-2 · Gully, MNNTSB CHI81DER45Accident · No injuriesClosedPiper PA-28 · Angle Inlet, MNNTSB CHI81DER46Accident · No injuriesClosedCessna 180 · Afton, MNNTSB CHI81FA066Accident · 1 fatalClosedPiper PA-32R · Crystal, MNNTSB CHI81DER44Accident · No injuriesClosedCessna A188 · Thief Rvr Fall, MNNTSB CHI81DER43Accident · Minor injuriesClosedCessna 188A · Wabasso, MNNTSB CHI81FER42Accident · No injuriesClosedCallair A-9B · Hector, MNNTSB CHI81FER41Accident · No injuriesClosedCessna A188B · Villard, MNNTSB CHI81FER39Accident · Serious injuriesClosedPiper PA-25 · Lake Elmo, MNNTSB CHI81FER40Accident · No injuriesClosedCessna A188B · Leroy, MNNTSB CHI81FER38Accident · Minor injuriesClosedMcculloch J-2 · Owatonna, MNNTSB CHI81FER37Accident · No injuriesClosedPiper PA-28R · Detroit Lakes, MNNTSB CHI81FER35Accident · Minor injuriesClosedCessna 188 · Roseau, MNNTSB CHI81DER36Accident · No injuriesClosedGrumman G-164B · Angus, MNNTSB CHI81FER33Accident · Minor injuriesClosedCessna 180H · Grand Rapids, MNNTSB CHI81FER31Accident · Minor injuriesClosedPiper PA-28 · Worthington, MNNTSB CHI81FER30Accident · Serious injuriesClosedCessna A188B · Wolverton, MNNTSB CHI81FER32Accident · No injuriesClosedPiper PA-38 · Blaine, MNNTSB CHI81FER21Accident · No injuriesClosedCessna 195 · Redwood Falls, MNNTSB CHI81FER29Accident · No injuriesClosedBeech E-55 · Eden Prairie, MNNTSB CHI81FER28Accident · No injuriesClosedPiper PA-30 · Fosston, MNNTSB CHI81FER27Accident · No injuriesClosedCessna 150F · St Paul, MNNTSB CHI81FER17Accident · No injuriesClosedCessna 120 · Frost, MNNTSB CHI81FER26Accident · No injuriesClosedPiper PA-32 · Faribault, MNNTSB CHI81FER24Accident · No injuriesClosedCessna 210M · Ivanhoe, MNNTSB CHI81DER25Accident · No injuriesClosedCessna 182RG · Warren, MNNTSB CHI81DER23Accident · No injuriesClosedPiper PA-23 · Roseau, MNNTSB CHI81FER22Accident · No injuriesClosedCessna 152 · Duluth, MNNTSB CHI81DER19Accident · No injuriesClosedWar Corsair · Blue Earth, MNNTSB CHI81DER20Accident · No injuriesClosedCessna 172F · Slaton, MNNTSB CHI81FER16Accident · Minor injuriesClosedMooney M20 · Lacrescent, MNNTSB CHI81DER18Accident · No injuriesClosedPiper PA-12 · Kelliher, MNNTSB CHI81FER14Accident · No injuriesClosedPiper PA-23 · St.Michael, MNNTSB CHI81DER11Accident · No injuriesClosedCessna 140A · St Cloud, MNNTSB CHI81FER13Accident · Serious injuriesClosedPiper PA-32 · Webb Lake, MNNTSB CHI81FA023Accident · No injuriesClosedCessna U206F · Sherburne, MNNTSB CHI81FEX08Accident · No injuriesClosedBeech F33A · St.Paul, MN