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 MKC68D0047Accident · No injuriesClosedCessna 150 · Red Oak, IAJun 19, 1967 · N8106S · Substantial damage NTSB MKC68F0026Accident · No injuriesClosedCessna 170 · Larrabee, IAJun 16, 1967 · N2614D · Substantial damage NTSB MKC68F0019Accident · Serious injuriesClosedCallair A-5 · Algona, IAJun 16, 1967 · N9978C · Destroyed NTSB MKC68D0031Accident · No injuriesClosedPiper PA-28 · Iowa City, IAJun 11, 1967 · N6426W · Substantial damage NTSB MKC67D0619Accident · No injuriesClosedCessna 170B · Stratford, IAJun 10, 1967 · N1887C · Substantial damage NTSB MKC68D0041Accident · No injuriesClosedBellanca 14-192 · Hawarden, IAJun 8, 1967 · N9803B · Substantial damage NTSB MKC67A0077Accident · 1 fatalClosedPiper PA-11 · Farragut, IAJun 5, 1967 · N4704H · Destroyed NTSB MKC68D0005Accident · No injuriesClosedAlon A-2 · Shenandoah, IAJun 4, 1967 · N6588Q · Substantial damage NTSB MKC68D0002Accident · Minor injuriesClosedLuscombe 8E · Grundy Centr, IAMay 31, 1967 · N28612 · Substantial damage NTSB MKC67D0601Accident · No injuriesClosedCessna 182A · Ottumwa, IAMay 31, 1967 · N2187G · Substantial damage NTSB MKC67A0074Accident · 2 fatalClosedMooney M20D · Boone, IAMay 31, 1967 · N5713Q · Destroyed NTSB MKC68D0001Accident · No injuriesClosedCessna 172 · Marion, IAMay 24, 1967 · N2526Y · Substantial damage NTSB MKC68D0006Accident · No injuriesClosedPiper J-3 · Denison, IAMay 21, 1967 · N24603 · Substantial damage NTSB MKC67D0590Accident · No injuriesClosedLuscombe 8E · Creston, IAMay 16, 1967 · N1977K · Substantial damage NTSB MKC68D0109Accident · No injuriesClosedMooney M20C · Treynor, IAMay 14, 1967 · N6716U · Substantial damage NTSB MKC67D0577Accident · No injuriesClosedBeech 35-C33 · Dubuque, IAMay 13, 1967 · N9493S · Substantial damage NTSB MKC67D0583Accident · Minor injuriesClosedCessna 172 · Pella, IAMay 7, 1967 · N8871B · Destroyed NTSB MKC67D0570Accident · No injuriesClosedCessna 172 · Grimes, IAMay 7, 1967 · N1338F · Substantial damage NTSB MKC67D0518Accident · No injuriesClosedPiper PA-22 · Van Meter, IAMay 7, 1967 · N9039D · Substantial damage NTSB MKC67D0595Accident · No injuriesClosedCessna 206 · Hancock, IAMay 3, 1967 · N5265U · Substantial damage NTSB MKC67D0571Accident · No injuriesClosedPiper PA-22 · Ankeny, IAMay 1, 1967 · N4526Z · Substantial damage NTSB MKC67D0553Accident · No injuriesClosedCessna 310C · Waterloo, IAMay 1, 1967 · N911D · Substantial damage NTSB MKC67D0582Accident · No injuriesClosedCessna 185 · Pella, IAApr 30, 1967 · N2694Z · Substantial damage NTSB MKC67D0526Accident · No injuriesClosedPiper PA-28 · Des Moines, IAApr 25, 1967 · N4266J · Substantial damage NTSB MKC67D0565Accident · No injuriesClosedPiper PA-12 · Mantelle, IAApr 24, 1967 · N3448M · Substantial damage NTSB MKC68A0061Accident · 1 fatalClosedPiper PA-30 · Charles City, IAApr 23, 1967 · N7784Y · Destroyed NTSB MKC67D0541Accident · No injuriesClosedPiper PA-28 · Shenandoah, IAApr 22, 1967 · N8210W · Substantial damage NTSB MKC67D0558Accident · No injuriesClosedCessna 150 · Dubuque, IAApr 14, 1967 · N3228J · Substantial damage NTSB MKC67D0503Accident · No injuriesClosedPiper PA-22 · Nevada, IAApr 11, 1967 · N6875B · Substantial damage NTSB MKC67F0525Accident · Serious injuriesClosedN. American P-51D · Des Moines, IAApr 6, 1967 · N169MD · Substantial damage NTSB MKC67D0527Accident · No injuriesClosedCessna 182 · Mason City, IAApr 5, 1967 · N7114E · Substantial damage NTSB MKC67D0500Accident · No injuriesClosedPiper PA-28 · Oskaloosa, IAApr 3, 1967 · N7884W · Substantial damage NTSB MKC67D0531Accident · No injuriesClosedCessna 150F · Sioux City, IAApr 2, 1967 · N8093F · Substantial damage NTSB MKC67F0484Accident · 1 fatalClosedAeronca 7AC · Plainfield, IAApr 1, 1967 · N1866A · Destroyed NTSB MKC67D0477Accident · No injuriesClosedPiper PA-22 · Denison, IAMar 28, 1967 · N3415A · Substantial damage NTSB MKC67D0535Accident · No injuriesClosedAeronca 7EC · Washburn, IAMar 24, 1967 · N4660E · Substantial damage NTSB MKC67D0499Accident · No injuriesClosedPiper PA-24 · Ralston, IAMar 22, 1967 · N5839P · Substantial damage NTSB MKC67D0523Accident · No injuriesClosedErcoupe 415-C · Jefferson, IAMar 16, 1967 · N93667 · Substantial damage NTSB MKC67D0470Accident · No injuriesClosedPiper PA-28 · Newton, IAMar 11, 1967 · N6332W · Substantial damage NTSB MKC67F0457Accident · No injuriesClosedBeech A23 · Cedar Rapids, IAMar 10, 1967 · N5959S · Substantial damage NTSB MKC67D0491Accident · No injuriesClosedCessna 175 · Laurens, IAMar 10, 1967 · N6566E · Substantial damage NTSB MKC67D0478Accident · No injuriesClosedCessna 172 · Eldora, IAMar 6, 1967 · N4186L · Substantial damage NTSB MKC67A0053Accident · No injuriesClosedCessna 182 · Des Moines, IAMar 6, 1967 · N2448X · No damage NTSB MKC67A0051Accident · No injuriesClosedBrantly B-2B · Cedar Rapids, IAMar 3, 1967 · N2175U · Substantial damage NTSB MKC67D0462Accident · No injuriesClosedPiper PA-22 · Sac City, IAFeb 26, 1967 · N3533Z · Substantial damage NTSB MKC67F0472Accident · No injuriesClosedMooney M20B · Grimes, IAFeb 24, 1967 · N74723 · Substantial damage NTSB MKC67A0049Accident · 3 fatalClosedBeech 23 · Maquoketa, IAFeb 15, 1967 · N2318Q · Destroyed NTSB MKC67D0444Accident · No injuriesClosedPiper PA-28 · Davenport, IAFeb 9, 1967 · N5427W · Substantial damage NTSB MKC67D0429Accident · No injuriesClosedPiper PA-22 · Iowa City, IAFeb 4, 1967 · N8867C · Substantial damage NTSB MKC67D0490Accident · No injuriesClosedCessna 182B · Mt. Pleasant, IAFeb 3, 1967 · N2319G · Substantial damage