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 MKC73FCD10Accident · Serious injuriesClosedPiper PA-30 · Sully, IAJul 30, 1972 · N8798Y · Destroyed NTSB MKC73DCD14Accident · No injuriesClosedPiper PA-28 · Moorland, IAJul 30, 1972 · N8663W · Substantial damage NTSB MKC73FCD24Accident · No injuriesClosedCessna 150H · Oskaloosa, IAJul 25, 1972 · N23448 · Substantial damage NTSB MKC73DCD06Accident · No injuriesClosedCessna 140 · Toledo, IAJul 23, 1972 · N1859V · Substantial damage NTSB MKC73DCD05Accident · No injuriesClosedMooney M20C · Radcliffe, IAJul 20, 1972 · N9322V · Substantial damage NTSB MKC73FCD03Accident · No injuriesClosedCessna 180 · Iowa City, IAJul 16, 1972 · N1508C · 2 aircraft · Minor damage NTSB MKC73DCD08Accident · No injuriesClosedStinson 10A · Kiron, IAJul 16, 1972 · N39492 · Substantial damage NTSB MKC73DCD02Accident · Minor injuriesClosedMooney M20C · Belle Plaine, IAJul 16, 1972 · N6295U · Substantial damage NTSB MKC73FCD04Accident · Serious injuriesClosedGrumman G164 · Northwood, IAJul 15, 1972 · N7228 · Destroyed NTSB MKC73DCD07Accident · No injuriesClosedCessna 172I · Traer, IAJul 14, 1972 · N8344L · Substantial damage NTSB MKC73DCD01Accident · No injuriesClosedCessna 172H · Cresco, IAJul 8, 1972 · N1433F · Substantial damage NTSB MKC72DCD74Accident · Minor injuriesClosedGrumman G-164A · Ottumwa, IAJun 6, 1972 · N8384 · Destroyed NTSB MKC72DCD75Accident · No injuriesClosedBeech V35 · Akron, IAJun 4, 1972 · N5453U · Substantial damage NTSB MKC72DCD73Accident · Minor injuriesClosedStinson 10A · Troy Mills, IAJun 4, 1972 · N39485 · Substantial damage NTSB MKC72DCD72Accident · No injuriesClosedLuscombe 8A · Missouri Vly, IAMay 27, 1972 · N71365 · Substantial damage NTSB MKC72FCD70Accident · No injuriesClosedCessna 172K · Des Moines, IAMay 25, 1972 · N46498 · Substantial damage NTSB MKC72FCD68Accident · No injuriesClosedCessna 172 · Storm Lake, IAMay 20, 1972 · N7497A · Substantial damage NTSB MKC72AK061Accident · 2 fatalClosedCessna 150K · Grimes, IAMay 18, 1972 · N8461M · Destroyed NTSB MKC72DCD69Accident · No injuriesClosedBeech B35 · Garner, IAMay 12, 1972 · N1177 · Substantial damage NTSB MKC72DCD71Accident · No injuriesClosedCessna 150G · Marion, IAMay 11, 1972 · N2979J · Substantial damage NTSB MKC72DCD67Accident · No injuriesClosedCessna 185 · Council Blfs, IAApr 17, 1972 · N4010Y · Destroyed NTSB MKC72DCD66Accident · No injuriesClosedCessna 170 · Paullina, IAApr 6, 1972 · N3101B · Substantial damage NTSB MKC72AK057Accident · 4 fatalClosedBeech C35 · Alta, IAMar 26, 1972 · N5844C · Destroyed NTSB MKC72FCD64Accident · No injuriesClosedLuscombe 8E · Adel, IAMar 25, 1972 · N1306B · Substantial damage NTSB MKC72FCD65Accident · No injuriesClosedPiper PA-30 · Des Moines, IAMar 23, 1972 · N948SB · Substantial damage NTSB MKC72FCD63Accident · Minor injuriesClosedBell 47G-2 · Fremont, IAMar 20, 1972 · N976B · Substantial damage NTSB MKC72DCD62Accident · No injuriesClosedAeronca 11AC · Shenandoah, IAFeb 20, 1972 · N3380E · Substantial damage NTSB MKC72DCD57Accident · No injuriesClosedCessna 150 · Maurice, IAFeb 15, 1972 · N3552L · Substantial damage NTSB MKC72DCD61Accident · No injuriesClosedCessna 172 · Gilman, IAFeb 13, 1972 · N4375Q · Substantial damage NTSB MKC72DCD58Accident · No injuriesClosedBeech 23 · Waterloo, IAFeb 11, 1972 · N8702M · Substantial damage NTSB MKC72DCD60Accident · No injuriesClosedCessna 182 · Sioux City, IAFeb 5, 1972 · N2720F · Substantial damage NTSB MKC72DCD59Accident · No injuriesClosedChampion 7ECA · Mediapolis, IAFeb 5, 1972 · N11055 · Substantial damage NTSB MKC72DCD56Accident · No injuriesClosedBeech B23 · Davenport, IAFeb 3, 1972 · N2315L · Substantial damage NTSB MKC72DCD53Accident · No injuriesClosedCessna 150E · Marion, IAJan 22, 1972 · N2571J · Substantial damage NTSB MKC72DCD55Accident · No injuriesClosedCessna 120 · Forest City, IAJan 9, 1972 · N2075V · Substantial damage NTSB MKC72DCD52Accident · No injuriesClosedCessna 150L · Garner, IAJan 6, 1972 · N1616Q · Substantial damage NTSB MKC72DCD51Accident · No injuriesClosedCessna 172 · Belmond, IAJan 6, 1972 · N7059A · Substantial damage NTSB MKC72FCD50Accident · No injuriesClosedPiper PA-32 · Mason City, IAJan 4, 1972 · N4215T · Substantial damage NTSB MKC72AK041Accident · 2 fatalClosedPiper PA-28R · Davenport, IADec 25, 1971 · N7477J · Destroyed NTSB MKC72FCD49Accident · Serious injuriesClosedMitsubishi MU-2B · Lemars, IADec 22, 1971 · N251M · No damage NTSB MKC72AK038Accident · 1 fatalClosedErco 415C · Lake Mills, IADec 19, 1971 · N93703 · Destroyed NTSB MKC72DCD48Accident · No injuriesClosedPiper PA-20 · Woodbine, IADec 10, 1971 · N7044K · Substantial damage NTSB MKC73DCD19Accident · No injuriesClosedAeronca 7AC · Decorah, IADec 4, 1971 · N85286 · Substantial damage NTSB MKC72DCD47Accident · No injuriesClosedPiper PA-32 · Dubuque, IANov 17, 1971 · N4139W · Substantial damage NTSB MKC72FCD44Accident · No injuriesClosedPiper PA-28 · Newton, IANov 14, 1971 · N6649J · Substantial damage NTSB MKC72DCD45Accident · No injuriesClosedPiper PA-32 · Ida Grove, IANov 14, 1971 · N4063R · Substantial damage NTSB MKC72DCD46Accident · No injuriesClosedCessna 140 · Chillicothe, IANov 7, 1971 · N1621V · Substantial damage NTSB MKC72DCD43Accident · Minor injuriesClosedCessna 140 · Mapleton, IANov 6, 1971 · N89093 · Substantial damage NTSB MKC72DCD42Accident · No injuriesClosedCessna 170A · Marion, IAOct 31, 1971 · N9145A · Substantial damage NTSB MKC72DCD40Accident · No injuriesClosedAero Comdr 500-B · Waterloo, IAOct 18, 1971 · N553HH · Substantial damage