Skip to content

NTSB investigations, IA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 MKC71DCD87Accident · No injuriesClosedBeech 35-C33 · Centerville, IAJun 11, 1971 · N5454U · Substantial damage NTSB MKC71DGD90Accident · No injuriesClosedCessna 180 · Fort Dodge, IAJun 10, 1971 · N9175C · Substantial damage NTSB MKC71FCD85Accident · No injuriesClosedBeech A35 · Davenport, IAJun 4, 1971 · N8666A · Substantial damage NTSB MKC71DCD86Accident · No injuriesClosedHughes 269B · Nora Springs, IAJun 2, 1971 · N9315F · Substantial damage NTSB MKC71FCD84Accident · 1 fatalClosedGrumman TBM-3E · Mapleton, IAMay 20, 1971 · N9599C · Destroyed NTSB MKC71DCD82Accident · No injuriesClosedBeech B23 · Tama, IAMay 8, 1971 · N2384J · Substantial damage NTSB MKC71DCD81Accident · No injuriesClosedPiper PA-28 · Guthrie Ctr, IAMay 8, 1971 · N7179R · Substantial damage NTSB MKC71DCD80Accident · No injuriesClosedCessna 150G · Grundy Ctr, IAMay 5, 1971 · N3993J · Substantial damage NTSB MKC71FCD79Accident · Serious injuriesClosedPiper J4-A · Clear Lake, IAApr 29, 1971 · N23332 · Destroyed NTSB MKC71DCD78Accident · Serious injuriesClosedCessna 140 · Lamoni, IAApr 26, 1971 · N89355 · Destroyed NTSB MKC71FCD77Accident · No injuriesClosedPiper PA-28 · Iowa City, IAApr 24, 1971 · N5682U · Substantial damage NTSB MKC71FCD76Accident · Serious injuriesClosedPiper PA-22 · Fairfield, IAApr 23, 1971 · N5211Z · Destroyed NTSB MKC71DGD75Accident · No injuriesClosedPiper PA-28 · Grimes, IAApr 21, 1971 · N9387W · Substantial damage NTSB MKC71DCD72Accident · No injuriesClosedPiper PA-32 · Kingsley, IAApr 16, 1971 · N3954W · Substantial damage NTSB MKC71DCD73Accident · No injuriesClosedBeech 35 · Rockwell Cty, IAApr 8, 1971 · N5783N · Substantial damage NTSB MKC71DCD71Accident · No injuriesClosedPiper PA-28 · Pella, IAApr 8, 1971 · N5254L · Substantial damage NTSB MKC71DCD69Accident · Minor injuriesClosedPiper PA-15 · Ankeny, IAApr 7, 1971 · N4571H · Substantial damage NTSB MKC71DCD67Accident · No injuriesClosedCessna 180 · Creson, IAApr 7, 1971 · N7813A · Substantial damage NTSB MKC71FCD68Accident · No injuriesClosedChampion 7KCAB · Williamsburg, IAApr 3, 1971 · N5067X · Substantial damage NTSB MKC71DCD70Accident · No injuriesClosedAmer Avco AA-1A · Shenandoah, IAApr 3, 1971 · N9321L · Substantial damage NTSB MKC71FCD66Accident · No injuriesClosedBeech K35 · Mason City, IAMar 28, 1971 · N6089E · Substantial damage NTSB MKC71DCD64Accident · No injuriesClosedCessna 172 · Traer, IAMar 17, 1971 · N6932A · Substantial damage NTSB MKC71DCD65Accident · No injuriesClosedCessna 177 · Newton, IAMar 13, 1971 · N2995Y · Substantial damage NTSB MKC71AK048Accident · 2 fatalClosedBeech A45 · Boone, IAMar 13, 1971 · N9716Z · Destroyed NTSB MKC71DCD63Accident · No injuriesClosedCessna 182 · Waterloo, IAMar 6, 1971 · N5418B · Substantial damage NTSB MKC71FCD62Accident · No injuriesClosedCessna 170A · Leclaire, IAMar 4, 1971 · N9735A · Substantial damage NTSB MKC71FCD60Accident · Serious injuriesClosedCessna U206E · Soldier, IAFeb 26, 1971 · N9442G · Substantial damage NTSB MKC71DCD59Accident · No injuriesClosedPiper PA-32 · Guthrie Cntr, IAFeb 19, 1971 · N4806S · Substantial damage NTSB MKC71FCD58Accident · Minor injuriesClosedPiper PA-31 · Iowa City, IAFeb 18, 1971 · N8000Y · Destroyed NTSB MKC71AK046Accident · 1 fatalClosedChampion 8KCAB · Clinton, IAFeb 18, 1971 · N9020L · Destroyed NTSB MKC71DCD61Accident · No injuriesClosedCessna 150G · Des Moines, IAFeb 11, 1971 · N3903J · Substantial damage NTSB MKC71FCD56Accident · No injuriesClosedPiper PA-32 · Grimes, IAFeb 10, 1971 · N4139W · Substantial damage NTSB MKC71AK044Accident · 1 fatalClosedCessna 172G · Marshalltown, IAFeb 6, 1971 · N4678L · 2 aircraft · Destroyed NTSB MKC71FCD53Accident · No injuriesClosedPiper PA-23 · Fairfield, IAJan 27, 1971 · N6732Y · Substantial damage NTSB MKC71DCD54Accident · No injuriesClosedCessna 172 · Creston, IAJan 25, 1971 · N6833A · Substantial damage NTSB MKC71DCD52Accident · No injuriesClosedAero Comdr 100 · Shenandoah, IAJan 16, 1971 · N5539M · Substantial damage NTSB MKC71DCD51Accident · No injuriesClosedCessna 172 · Ottumwa, IAJan 16, 1971 · N8485U · Substantial damage NTSB MKC71DCD57Accident · No injuriesClosedPiper PA-28 · Iowa City, IAJan 15, 1971 · N5020W · Substantial damage NTSB MKC71DCD50Accident · No injuriesClosedPiper PA-24 · Iowa City, IAJan 13, 1971 · N7768P · Substantial damage NTSB MKC71AK039Accident · No injuriesClosedCessna 310J · Burlington, IAJan 12, 1971 · N3024L · Substantial damage NTSB MKC71FCD49Accident · Minor injuriesClosedPiper PA-22 · Elkhart, IAJan 10, 1971 · N8622D · Substantial damage NTSB MKC71DCD55Accident · No injuriesClosedPiper PA-28 · Wapello, IAJan 2, 1971 · N170S · Substantial damage NTSB MKC71DCD48Accident · No injuriesClosedCessna 182A · Fairfield, IAJan 1, 1971 · N4749D · Substantial damage NTSB MKC71DCD46Accident · No injuriesClosedBeech 95-B55 · Mason City, IADec 31, 1970 · N291BP · Substantial damage NTSB MKC71DCD47Accident · Serious injuriesClosedCessna 182J · Mason City, IADec 27, 1970 · N2857F · No damage NTSB MKC71DCD42Accident · No injuriesClosedPiper PA-22 · Sibley, IADec 27, 1970 · N6836B · Substantial damage NTSB MKC71DCD45Accident · No injuriesClosedChampion 7ECA · Council Bluf, IADec 20, 1970 · N11098 · Substantial damage NTSB MKC71DCD43Accident · No injuriesClosedPiper PA-24 · Shenandoah, IADec 19, 1970 · N9164P · Substantial damage NTSB MKC71FCD41Accident · Minor injuriesClosedCessna 182J · Oskaloosa, IADec 18, 1970 · N3136F · Substantial damage NTSB MKC71DCD44Accident · No injuriesClosedCessna 150E · Johnston, IADec 13, 1970 · N6230R · Substantial damage