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 UNK64X4193Accident · No injuriesClosedPiper PA22 · Council Bluff, IASep 28, 1964 · N3664P · Substantial damage NTSB UNK64X4183Accident · No injuriesClosedCessna 140 · Ames, IASep 27, 1964 · N77075 · Destroyed NTSB UNK64X4112Accident · No injuriesClosedPiper PA22 · Webster City, IASep 23, 1964 · N5708D · Substantial damage NTSB UNK64X3987Accident · No injuriesClosedCessna 205 · Red Oak, IASep 14, 1964 · N8257Z · Substantial damage NTSB UNK64X3961Accident · No injuriesClosedPiper PA28 · Woolstock, IASep 13, 1964 · N5286W · Substantial damage NTSB UNK64X3917Accident · No injuriesClosedCessna 182 · Lemars, IASep 11, 1964 · N5113D · Substantial damage NTSB UNK64X3876Accident · No injuriesClosedBeechcraft T34 · Elkader, IASep 8, 1964 · N7611B · Substantial damage NTSB UNK64X3772Accident · No injuriesClosedBeechcraft B55 · Oskaloosa, IASep 4, 1964 · N8849M · Substantial damage NTSB UNK64X3752Accident · No injuriesClosedBeechcraft B35 · Perry, IASep 3, 1964 · N8916A · Substantial damage NTSB UNK64X3749Accident · No injuriesClosedFairchild 24J · Ottumwa, IASep 3, 1964 · N19177 · Substantial damage NTSB UNK64X3690Accident · No injuriesClosedMooney MK20A · Leon, IAAug 30, 1964 · N8102E · Substantial damage NTSB UNK64X3588Accident · Minor injuriesClosedGrumman SCAN30 · Fairfield, IAAug 25, 1964 · N7916C · Destroyed NTSB UNK64X3538Accident · No injuriesClosedStinson 108 · Marion, IAAug 22, 1964 · N97656 · Substantial damage NTSB UNK64X3517Accident · No injuriesClosedStinson 108-2 · Des Moines, IAAug 21, 1964 · N9478K · Substantial damage NTSB UNK64X3509Accident · No injuriesClosedCessna 310 · Red Oak, IAAug 21, 1964 · N5839X · Substantial damage NTSB UNK64X3428Accident · No injuriesClosedChampion 75C · Waukon, IAAug 16, 1964 · N9843Y · Substantial damage NTSB UNK64X3361Accident · No injuriesClosedBeechcraft F35 · Shenandoah, IAAug 13, 1964 · N3840B · Substantial damage NTSB UNK64X3355Accident · No injuriesClosedPiper PA28 · Clarion, IAAug 13, 1964 · N7372W · Substantial damage NTSB UNK64X3343Accident · No injuriesClosedBeechcraft A45 · Des Moines, IAAug 12, 1964 · N74009 · Substantial damage NTSB UNK64X3342Accident · No injuriesClosedPiper PA24 · Kalona, IAAug 12, 1964 · N6890P · Substantial damage NTSB UNK64X3317Accident · No injuriesClosedChampion 7FC · Forest City, IAAug 10, 1964 · N9897B · Substantial damage NTSB UNK64X3259Accident · No injuriesClosedPiper PA22 · Crescent, IAAug 7, 1964 · N7019B · Substantial damage NTSB UNK64X3200Accident · Minor injuriesClosedPiper PA16 · Grimes, IAAug 3, 1964 · N5728H · Substantial damage NTSB UNK64X3148Accident · No injuriesClosedPiper PA28 · Spencer, IAAug 1, 1964 · N5239W · Substantial damage NTSB UNK64X3103Accident · No injuriesClosedCessna 120 · Laporte City, IAJul 29, 1964 · N2081V · Substantial damage NTSB UNK64X3091Accident · No injuriesClosedHughes 269A · Audubon, IAJul 28, 1964 · N8841F · Substantial damage NTSB UNK64X3082Accident · No injuriesClosedPiper PA28 · Iowa City, IAJul 28, 1964 · N8558W · Substantial damage NTSB UNK64X3010Accident · No injuriesClosedPiper PA24 · Keosauqua, IAJul 24, 1964 · N5748P · Substantial damage NTSB UNK64X2774Accident · No injuriesClosedBeechcraft 35 · Okoboji, IAJul 12, 1964 · N2859V · Substantial damage NTSB UNK64X2748Accident · Minor injuriesClosedCessna 140A · St Ansgar, IAJul 10, 1964 · N14310 · Substantial damage NTSB UNK64X2588Accident · No injuriesClosedNavion G · Des Moines, IAJul 1, 1964 · N2417T · Substantial damage NTSB UNK64X2310Accident · Serious injuriesClosedPiper PA-24 · Corning, IAJun 15, 1964 · N7681P · Destroyed NTSB UNK64X2289Accident · No injuriesClosedCessna 210 · Dubuque, IAJun 14, 1964 · N9440T · Substantial damage NTSB UNK64X2151Accident · Minor injuriesClosedAeronca 7AC · Red Oak, IAJun 6, 1964 · N84230 · Destroyed NTSB UNK64X1959Accident · Serious injuriesClosedCessna 182 · Grinnell, IAMay 26, 1964 · N5562B · Destroyed NTSB UNK64X1932Accident · No injuriesClosedAeronca 15AC · Eldora, IAMay 24, 1964 · N1103H · Substantial damage NTSB UNK64X1905Accident · No injuriesClosedCessna 140 · Marion, IAMay 23, 1964 · N81030 · Substantial damage NTSB UNK64X1786Accident · No injuriesClosedStinson 108-3 · Burlington, IAMay 16, 1964 · N6103M · Substantial damage NTSB UNK64X1770Accident · No injuriesClosedBeechcraft 23 · Denison, IAMay 15, 1964 · N2344Z · Substantial damage NTSB UNK64X1754Accident · Minor injuriesClosedPiper PA22 · Charles City, IAMay 13, 1964 · N3365Z · Substantial damage NTSB UNK64X1681Accident · No injuriesClosedPiper PA22 · Davenport, IAMay 9, 1964 · N2297A · Substantial damage NTSB UNK64X1666Accident · No injuriesClosedBeechcraft 35J · Okoboji, IAMay 8, 1964 · N3057C · Substantial damage NTSB UNK64X1621Accident · Serious injuriesClosedPiper PA22 · Fairfield, IAMay 4, 1964 · N5932D · Substantial damage NTSB UNK64X1594Accident · No injuriesClosedCessna 175 · Clear Lake, IAMay 3, 1964 · N7691M · Substantial damage NTSB UNK64X1536Accident · No injuriesClosedGlobe Swift GC1B · Bloomfield, IAApr 30, 1964 · N80534 · Substantial damage NTSB UNK64X1516Accident · No injuriesClosedPiper PA22 · Red Oak, IAApr 29, 1964 · N7822D · Substantial damage NTSB UNK64X1443Accident · Minor injuriesClosedLuscombe 8A · Toledo, IAApr 25, 1964 · N71259 · Destroyed NTSB UNK64X1399Accident · No injuriesClosedPiper PA22 · Davenport, IAApr 21, 1964 · N3202B · Substantial damage NTSB UNK64X1223Accident · No injuriesClosedPiper PA22 · Traer, IAApr 8, 1964 · N8871C · Substantial damage NTSB UNK64X1120Accident · Serious injuriesClosedAeronca 11AC · Council Bluffs, IAMar 31, 1964 · N3803E · Substantial damage