Skip to content

NTSB investigations, IA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 MKC66D0550Accident · No injuriesClosedPiper PA-22 · Mason City, IAMar 26, 1966 · N8421D · Substantial damage NTSB MKC66F0475Accident · No injuriesClosedPiper PA-22 · Des Moines, IAMar 18, 1966 · N8876D · Substantial damage NTSB MKC66D0512Accident · No injuriesClosedBeech S35 · Hawarden, IAMar 14, 1966 · N198Q · Substantial damage NTSB MKC66D0500Accident · No injuriesClosedPiper PA-28 · Sioux City, IAMar 12, 1966 · N6802W · Substantial damage NTSB MKC66D0476Accident · No injuriesClosedCessna 320C · Mason City, IAMar 11, 1966 · N3051T · Substantial damage NTSB MKC66D0449Accident · No injuriesClosedPiper PA-22 · Perry, IAFeb 27, 1966 · N2609A · Substantial damage NTSB MKC66F0419Accident · No injuriesClosedCessna P206 · Des Moines, IAFeb 26, 1966 · N2530X · Substantial damage NTSB MKC66A0043Accident · Serious injuriesClosedHawker-Sdly DH-125 · Des Moines, IAFeb 24, 1966 · N1135K · Substantial damage NTSB MKC66F0447Accident · No injuriesClosedBeech E18S · Des Moines, IAFeb 23, 1966 · N3333C · Substantial damage NTSB MKC66D0416Accident · No injuriesClosedPiper PA-28 · Storm Lake, IAFeb 7, 1966 · N7321W · Substantial damage NTSB MKC66F0458Accident · No injuriesClosedBellanca 14-13 · Grimes, IAFeb 1, 1966 · N86798 · Substantial damage NTSB MKC66F0392Accident · No injuriesClosedPiper PA-23 · Garner, IAJan 27, 1966 · N3325P · Substantial damage NTSB MKC66F0402Accident · No injuriesClosedCessna 310H · Des Moines, IAJan 19, 1966 · N1142Q · Substantial damage NTSB MKC66F0397Accident · No injuriesClosedCessna 310J · Des Moines, IAJan 14, 1966 · N3100L · Substantial damage NTSB MKC66D0385Accident · No injuriesClosedCessna 120 · Des Moines, IAJan 9, 1966 · N72715 · Substantial damage NTSB MKC66D0337Accident · No injuriesClosedStinson 108-2 · Panoro, IAJan 1, 1966 · N9551K · Substantial damage NTSB MKC66D0364Accident · No injuriesClosedCessna 182 · Centerville, IADec 30, 1965 · N8304S · Substantial damage NTSB MKC66D0366Accident · No injuriesClosedBeech A23 · Marion, IADec 29, 1965 · N8857M · Substantial damage NTSB MKC66D0370Accident · No injuriesClosedForney 415-C · Allerton, IADec 27, 1965 · N94041 · Substantial damage NTSB MKC66F0351Accident · No injuriesClosedPiper PA-24 · Jefferson, IADec 1, 1965 · N6455P · Substantial damage NTSB MKC66F0359Accident · No injuriesClosedPiper PA-24 · Estherville, IANov 29, 1965 · N8606P · Substantial damage NTSB MKC66A0032Accident · 1 fatalClosedBeech 35-33 · Hills, IANov 26, 1965 · N829R · Destroyed NTSB MKC66D0362Accident · No injuriesClosedTaylorcraft L-2 · Adair, IANov 21, 1965 · N48247 · Substantial damage NTSB MKC66D0324Accident · No injuriesClosedPiper PA-24 · Mt Ayr, IANov 14, 1965 · N8847P · Substantial damage NTSB MKC66F0301Accident · No injuriesClosedCessna 172D · Des Moines, IANov 12, 1965 · N2580U · Substantial damage NTSB MKC66A0030Accident · 2 fatalClosedUniversal GC-1B · Council Bluffs, IANov 6, 1965 · N3832K · Destroyed NTSB MKC66F0352Accident · No injuriesClosedCessna 210D · Ottumwa, IANov 5, 1965 · N3745Y · Substantial damage NTSB MKC66F0322Accident · No injuriesClosedPiper PA-30 · Des Moines, IANov 5, 1965 · N7545Y · Substantial damage NTSB MKC66F0322Accident · Minor injuriesClosedPiper PA-12 · Fort Dodge, IANov 2, 1965 · N3812M · Substantial damage NTSB MKC66D0330Accident · Minor injuriesClosedCessna 172 · Waukon, IAOct 29, 1965 · N5491R · Substantial damage NTSB MKC66F0388Accident · No injuriesClosedCessna 210D · Corning, IAOct 20, 1965 · N3764Y · Substantial damage NTSB MKC66D0298Accident · No injuriesClosedPiper PA-24 · Guthrie Cntr, IAOct 19, 1965 · N7189P · Substantial damage NTSB DEN66A0027Accident · 1 fatalClosedCessna 150E · Newton, IAOct 14, 1965 · N8883S · Destroyed NTSB MKC66D0305Accident · No injuriesClosedAeronca 7FC · Washburn, IAOct 13, 1965 · N9897B · Substantial damage NTSB MKC66D0287Accident · No injuriesClosedBeechcraft 35 · Council Bluffs, IAOct 12, 1965 · N3217V · Substantial damage NTSB MKC66F0248Accident · Minor injuriesClosedPiper PA-12 · Lemars, IAOct 9, 1965 · N4035M · Substantial damage NTSB MKC66D0276Accident · No injuriesClosedPiper PA-22 · Algona, IAOct 5, 1965 · N3386A · Substantial damage NTSB MKC66D0230Accident · No injuriesClosedCessna 175 · Boone, IASep 26, 1965 · N8372T · Substantial damage NTSB MKC66A0020Accident · Serious injuriesClosedDouglas DC-6B · Des Moines, IASep 22, 1965 · N3759 · Substantial damage NTSB MKC66F0229Accident · Serious injuriesClosedPiper PA-28 · Pacific Jctn, IASep 21, 1965 · N8282W · Substantial damage NTSB MKC66D0237Accident · No injuriesClosedPiper PA-23 · Iowa Falls, IASep 17, 1965 · N3325P · Substantial damage NTSB MKC66F0206Accident · No injuriesClosedPiper PA-28 · Joice, IASep 12, 1965 · N6461W · Substantial damage NTSB MKC66D0236Accident · No injuriesClosedCessna 210 · Mapleton, IASep 9, 1965 · N9454T · Substantial damage NTSB MKC66D0221Accident · No injuriesClosedCessna 150 · West Point, IASep 7, 1965 · N3948U · Substantial damage NTSB MKC66D0205Accident · No injuriesClosedWaco RNF · Prairie City, IASep 4, 1965 · N140Y · Substantial damage NTSB MKC66D0213Accident · No injuriesClosedPiper PA-12 · Marion, IAAug 23, 1965 · N7502H · Substantial damage NTSB MKC66F0160Accident · No injuriesClosedCessna 172 · Adel, IAAug 21, 1965 · N6917X · Substantial damage NTSB MKC66D0168Accident · No injuriesClosedBeechcraft P-35 · Okoboji, IAAug 17, 1965 · N8625M · Substantial damage NTSB MKC66F0146Accident · No injuriesClosedPiper PA-18 · Ft Dodge, IAAug 12, 1965 · N2774P · Substantial damage NTSB MKC66D0219Accident · No injuriesClosedRobinson Mere M · Davis City, IAAug 8, 1965 · N6827D · Substantial damage