Skip to content

NTSB investigations, IA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"eventStateOrRegion\" = 'IA' 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 c."eventStateOrRegion" = 'IA' 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 MKC66D0166Accident · No injuriesClosedTaylorcraft 19 · Eagle Grove, IAAug 4, 1965 · N6630N · Substantial damage NTSB MKC66F0114Accident · No injuriesClosedGlobe GC-1B · Wellman, IAJul 31, 1965 · N78062 · Substantial damage NTSB MKC66A0007Accident · 1 fatalClosedPiper J3C-65 · Indianola, IAJul 27, 1965 · N38561 · Destroyed NTSB MKC66D0133Accident · Minor injuriesClosedCessna P206 · Oakland, IAJul 23, 1965 · N2569X · Substantial damage NTSB MKC66D0102Accident · No injuriesClosedBeechcraft H-35 · Cresco, IAJul 21, 1965 · N5565D · Substantial damage NTSB MKC66A0003Accident · Minor injuriesClosedBrantly B-2 · Cedar Rapids, IAJul 13, 1965 · N4990C · Substantial damage NTSB MKC66F0088Accident · No injuriesClosedPiper PA-28 · Newton, IAJun 25, 1965 · N6588W · Substantial damage NTSB MKC66F0073Accident · No injuriesClosedPiper PA-23 · Des Moines, IAJun 17, 1965 · N3348P · Substantial damage NTSB MKC66D0025Accident · No injuriesClosedPiper PA-15 · Riceville, IAJun 13, 1965 · N4189H · Destroyed NTSB MKC66D0068Accident · No injuriesClosedPiper PA-11 · Algona, IAJun 10, 1965 · N78751 · Destroyed NTSB MKC66D0076Accident · No injuriesClosedPiper PA-24 · Waterloo, IAJun 4, 1965 · N5455P · Substantial damage NTSB MKC66F0048Accident · Serious injuriesClosedAeronca 7AC · Richville, IAJun 1, 1965 · N85101 · Destroyed NTSB MKC66D0029Accident · No injuriesClosedBeechcraft P-35 · Spencer, IAMay 28, 1965 · N1538S · Substantial damage NTSB MKC65D0152Accident · Minor injuriesClosedNavion B-260 · Charles City, IAMay 19, 1965 · N5260K · Destroyed NTSB MKC65F0137Accident · No injuriesClosedPiper PA-22 · Ames, IAMay 13, 1965 · N2627P · Substantial damage NTSB MKC65D0127Accident · No injuriesClosedTaylorcraft DCO · Pacific Junct, IAMay 3, 1965 · N57922 · Destroyed NTSB MKC66D0077Accident · No injuriesClosedCessna 210 · Davenport, IAMay 1, 1965 · N740B · Substantial damage NTSB MKC65D0139Accident · No injuriesClosedAeronca 0-58B · Carroll, IAApr 30, 1965 · N48080 · Destroyed NTSB MKC65F0107Accident · Minor injuriesClosedPiper PA-22 · No Sioux City, IAApr 20, 1965 · N4872Z · Substantial damage NTSB MKC65F0124Accident · No injuriesClosedCessna 180 · Traer, IAApr 16, 1965 · N3108D · Substantial damage NTSB MKC66F0058Accident · Minor injuriesClosedCessna 172 · Murray, IAApr 11, 1965 · N5749A · Substantial damage NTSB MKC65D0088Accident · No injuriesClosedCessna 182 · Lansing, IAApr 11, 1965 · N5620B · Substantial damage NTSB MKC65D0115Accident · Minor injuriesClosedHelio H-395 · Dubuque, IAApr 9, 1965 · N4165D · Substantial damage NTSB MKC65D0072Accident · No injuriesClosedCessna 150A · Audubon, IAApr 6, 1965 · N6654T · Substantial damage NTSB MKC65F0102Accident · No injuriesClosedNavion G-1 · Sioux City, IAMar 28, 1965 · N2467T · Substantial damage NTSB MKC65F0073Accident · No injuriesClosedBeechcraft S-35 · Donnellson, IAMar 27, 1965 · N7936K · Substantial damage NTSB MKC65D0084Accident · No injuriesClosedPiper PA-28 · Sioux City, IAMar 20, 1965 · N8784W · Substantial damage NTSB MKC65D0069Accident · No injuriesClosedPiper PA-22 · Monticello, IAMar 20, 1965 · N7893D · Substantial damage NTSB MKC65D0138Accident · No injuriesClosedLuscombe 8A · Creston, IAMar 12, 1965 · N1990B · Substantial damage NTSB MKC65D0036Accident · No injuriesClosedPiper PA-20 · Dawson, IAMar 7, 1965 · N7711K · Substantial damage NTSB MKC65D0046Accident · No injuriesClosedCessna 140 · Davenport, IAMar 6, 1965 · N2733N · Substantial damage NTSB MKC65F0054Accident · No injuriesClosedPiper PA-16 · Centerville, IAFeb 20, 1965 · N5310H · Substantial damage NTSB MKC65D0029Accident · No injuriesClosedNavion A · Rock Valley, IAFeb 18, 1965 · N4599K · Substantial damage NTSB MKC65D0028Accident · No injuriesClosedPiper PA-22 · Ames, IAFeb 14, 1965 · N2627P · Substantial damage NTSB MKC65F0041Accident · No injuriesClosedPiper PA-24 · Clarinda, IAFeb 8, 1965 · N5196P · Substantial damage NTSB MKC65D0017Accident · No injuriesClosedMooney MD20 · Ames, IAFeb 8, 1965 · N1968Y · Substantial damage NTSB MKC65D0074Accident · No injuriesClosedPiper PA-22 · Pella, IAFeb 5, 1965 · N4701Z · Substantial damage NTSB MKC65F0004Accident · No injuriesClosedBeechraft 35 · Creston, IAFeb 1, 1965 · N80441 · Substantial damage NTSB MKC65D0018Accident · No injuriesClosedBeechraft 95-B55 · Fairfield, IAJan 25, 1965 · N7941K · Substantial damage NTSB MKC65F0008Accident · No injuriesClosedBeechraf F35 · Des Moines, IAJan 14, 1965 · N4217B · Substantial damage NTSB UNK65X1094Accident · No injuriesClosedMooney M21 · Grinnell, IADec 22, 1964 · N6679U · Substantial damage NTSB UNK65X1011Accident · No injuriesClosedBeechraft N35 · Centerville, IADec 14, 1964 · N545T · Substantial damage NTSB UNK65X0994Accident · No injuriesClosedCessna 175 · Mt Pleasant, IADec 13, 1964 · N9365B · Destroyed NTSB UNK65X0857Accident · No injuriesClosedBeechcraft D35 · Cedar Rapids, IANov 27, 1964 · N2973B · Substantial damage NTSB UNK65X0656Accident · No injuriesClosedCessna 210 · Knoxville, IANov 11, 1964 · N9657T · Substantial damage NTSB UNK65X0472Accident · No injuriesClosedPiper PA22 · What Cheer, IAOct 29, 1964 · N4556Z · Substantial damage NTSB UNK65X0371Accident · No injuriesClosedCessna 180 · Des Moines, IAOct 22, 1964 · N4868A · Substantial damage NTSB UNK65X0305Accident · Minor injuriesClosedAeronca 7AC · Floris, IAOct 17, 1964 · N84762 · Destroyed NTSB UNK65X0277Accident · No injuriesClosedPiper PA28 · Ft Dodge, IAOct 14, 1964 · N7557W · Substantial damage NTSB UNK65X0115Accident · No injuriesClosedBeechcraft 35 · Spencer, IAOct 2, 1964 · N270H · Substantial damage