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 MKC67D0175Accident · No injuriesClosedBeech A23 · Marshalltown, IAAug 17, 1966 · N2390W · Substantial damage NTSB MKC67F0124Accident · No injuriesClosedPiper PA-12 · Allison, IAAug 14, 1966 · N2674M · Substantial damage NTSB MKC67D0158Accident · No injuriesClosed172 · Dayton, IAAug 14, 1966 · N6055R · Substantial damage NTSB MKC67D0149Accident · No injuriesClosedBeech A23A · Council Blfs, IAAug 13, 1966 · N2307W · Substantial damage NTSB MKC67D0154Accident · No injuriesClosedCessna 150 · Davenport, IAAug 11, 1966 · N6292T · Substantial damage NTSB MKC67D0155Accident · No injuriesClosedCessna 140 · La Porte Cty, IAAug 10, 1966 · N1999N · Substantial damage NTSB MKC67F0147Accident · Minor injuriesClosedMong A-2 · Clinton, IAAug 7, 1966 · N100F · Destroyed NTSB MKC67F0112Accident · No injuriesClosedCessna 182B · Oskaloosa, IAAug 7, 1966 · N2611G · Substantial damage NTSB MKC67D0178Accident · No injuriesClosedBeech 23 · Charles City, IAAug 5, 1966 · N2369W · Substantial damage NTSB MKC67F0148Accident · Serious injuriesClosedPiper PA-25 · Blairstown, IAAug 4, 1966 · N7114Z · Substantial damage NTSB MKC67F0146Accident · Minor injuriesClosedCessna 182A · Mason City, IAAug 2, 1966 · N5183D · Substantial damage NTSB MKC67F0195Accident · No injuriesClosedPiper PA-24 · Des Moines, IAJul 30, 1966 · N5715P · Substantial damage NTSB MKC67F0122Accident · No injuriesClosedBeech S35 · Mason City, IAJul 29, 1966 · N8635Q · Substantial damage NTSB MKC67D0168Accident · No injuriesClosedAeronca 11AC · Imogene, IAJul 24, 1966 · N3223E · Substantial damage NTSB MKC67D0187Accident · No injuriesClosedErcoupe 415C · Knoxville, IAJul 23, 1966 · N87331 · Substantial damage NTSB MKC67A0006Accident · 2 fatalClosedBeech H35 · Sioux City, IAJul 23, 1966 · N354B · Destroyed NTSB MKC67A0004Accident · 3 fatalClosedCessna 172 · Lorimor, IAJul 22, 1966 · N8823B · Destroyed NTSB MKC67F0109Accident · No injuriesClosedPiper PA-18 · Bancroft, IAJul 19, 1966 · N2152A · Substantial damage NTSB MKC67D0121Accident · No injuriesClosedCessna 150 · Red Oak, IAJul 18, 1966 · N8106S · Substantial damage NTSB MKC67D0084Accident · No injuriesClosedErcoupe 415C · Rockwell Cty, IAJul 16, 1966 · N3469H · Substantial damage NTSB MKC67F0611Accident · Serious injuriesClosedPiper PA-18 · Stanwood, IAJul 15, 1966 · N5697Y · Destroyed NTSB MKC67F0085Accident · No injuriesClosedErcoupe 415C · Nevada, IAJul 10, 1966 · N87007 · Substantial damage NTSB MKC67D0113Accident · No injuriesClosedBeech A23 · Central City, IAJul 10, 1966 · N8793M · Substantial damage NTSB MKC67D0056Accident · No injuriesClosedPiper PA-18 · Toledo, IAJul 5, 1966 · N8188C · Substantial damage NTSB MKC67F0015Accident · No injuriesClosedCessna 140 · Des Moines, IAJun 21, 1966 · N3621V · Substantial damage NTSB MKC67F0043Accident · No injuriesClosedBellanca 14-19 · Des Moines, IAJun 18, 1966 · N8510R · Substantial damage NTSB MKC67F0057Accident · No injuriesClosedBeech 35 · Lowden, IAJun 17, 1966 · N3751N · Substantial damage NTSB MKC67D0018Accident · No injuriesClosedCessna 182E · Des Moines, IAJun 17, 1966 · N3105Y · Substantial damage NTSB MKC67F0042Accident · Serious injuriesClosedCessna 170 · Grand River, IAJun 16, 1966 · N2580V · Substantial damage NTSB MKC67D0014Accident · No injuriesClosedCessna 140 · Corning, IAJun 11, 1966 · N76644 · Substantial damage NTSB MKC67D0013Accident · No injuriesClosedPiper PA-22 · Manson, IAJun 9, 1966 · N8516C · Substantial damage NTSB MKC67F0077Accident · No injuriesClosedCessna 206 · Council Bluf, IAJun 3, 1966 · N2569X · Substantial damage NTSB MKC66A0063Accident · Minor injuriesClosedHughes 269A · Walnut, IAMay 29, 1966 · N8842F · Destroyed NTSB MKC67D0065Accident · No injuriesClosedCessna 150 · Boone, IAMay 28, 1966 · N35311 · Substantial damage NTSB MKC66A0061Accident · No injuriesClosedPiper PA-25 · Mt.Union, IAMay 24, 1966 · N6170Z · Substantial damage NTSB MKC67F0066Accident · Minor injuriesClosedPiper PA-28 · Onawa, IAMay 20, 1966 · N8778W · Substantial damage NTSB MKC66F0582Accident · Minor injuriesClosedErco 415-C · Harlan, IAMay 20, 1966 · N99695 · Destroyed NTSB MKC67D0055Accident · No injuriesClosedCessna 150 · St.Donatus, IAMay 19, 1966 · N7271X · Destroyed NTSB MKC66D0566Accident · No injuriesClosedPiper PA-28 · Cresco, IAMay 1, 1966 · N8733M · Substantial damage NTSB MKC66F0548Accident · Serious injuriesClosedCessna 172 · St Donatus, IAApr 29, 1966 · N4103L · Substantial damage NTSB MKC67D0031Accident · No injuriesClosedPiper PA-11 · Stratford, IAApr 26, 1966 · N4688M · Substantial damage NTSB MKC66F0547Accident · No injuriesClosedBeech 95 · Newton, IAApr 26, 1966 · N2779Y · Substantial damage NTSB MKC66D0578Accident · No injuriesClosedCessna 175 · Kalona, IAApr 25, 1966 · N7148M · Substantial damage NTSB MKC66F0538Accident · No injuriesClosedPiper PA-23 · Iowa City, IAApr 20, 1966 · N3301P · Substantial damage NTSB MKC66D0541Accident · No injuriesClosedCessna 150 · Atlantic, IAApr 18, 1966 · N8807S · Substantial damage NTSB MKC66D0505Accident · No injuriesClosedBeech 23 · Iowa City, IAApr 9, 1966 · N8876M · Substantial damage NTSB MKC66D0525Accident · No injuriesClosedStinson SR-9E · Dallas Centr, IAApr 7, 1966 · N18437 · Substantial damage NTSB MKC66D0553Accident · No injuriesClosedPiper PA-23 · Guttenberg, IAMar 31, 1966 · N3229P · Substantial damage NTSB MKC66D0527Accident · No injuriesClosedCessna 172 · Creston, IAMar 31, 1966 · N3940S · Substantial damage NTSB MKC66D0509Accident · No injuriesClosedErcoupe 415-C · Marion, IAMar 27, 1966 · N2099H · Substantial damage