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 MKC68D0288Accident · No injuriesClosedBeech B35 · Hamburg, IAOct 21, 1967 · N5187C · Substantial damage NTSB MKC68D0285Accident · No injuriesClosedPiper PA-28 · Marshalltown, IAOct 21, 1967 · N3422K · Substantial damage NTSB MKC68F0282Accident · Serious injuriesClosedPiper PA-30 · Waterloo, IAOct 17, 1967 · N8306Y · Destroyed NTSB MKC68D0287Accident · No injuriesClosedCessna 170 · Waukon, IAOct 17, 1967 · N1243D · Substantial damage NTSB MKC68F0274Accident · No injuriesClosedCessna 180A · Rockwell Cty, IAOct 7, 1967 · N9731B · Substantial damage NTSB MKC68F0229Accident · Minor injuriesClosedPiper PA-18 · Henderson, IAOct 2, 1967 · N4117Z · Substantial damage NTSB MKC68D0235Accident · No injuriesClosedPiper PA-28 · Chariton, IASep 25, 1967 · N9428J · Destroyed NTSB MKC68D0234Accident · No injuriesClosedPiper PA-28 · Swea City, IASep 25, 1967 · N8655W · Substantial damage NTSB MKC68D0227Accident · No injuriesClosedBeech P35 · Spencer, IASep 24, 1967 · N8625M · Substantial damage NTSB MKC68D0221Accident · No injuriesClosedPiper PA-28 · Chariton, IASep 21, 1967 · N9428J · Substantial damage NTSB MKC68D0187Accident · No injuriesClosedCessna 172 · Corydon, IASep 15, 1967 · N6800A · Substantial damage NTSB MKC68F0230Accident · Serious injuriesClosedPiper PA-16 · Oskaloosa, IASep 12, 1967 · N5310H · Destroyed NTSB MKC68A0022Accident · No injuriesClosedHughes 269A · Silver City, IASep 8, 1967 · N8841F · Substantial damage NTSB MKC68D0210Accident · No injuriesClosedFairchild M-62 · Gilmore City, IASep 6, 1967 · N1134Z · Substantial damage NTSB MKC68A0020Accident · 1 fatalClosedMiniplane Smith · Eldridge, IASep 4, 1967 · N47P · Destroyed NTSB MKC68F0195Accident · Serious injuriesClosedStits SA6-B · Grinnell, IASep 2, 1967 · N4801E · Substantial damage NTSB MKC68F0206Accident · No injuriesClosedCessna 172 · Adel, IAAug 31, 1967 · N6408B · Substantial damage NTSB MKC68D0213Accident · No injuriesClosedMooney M20C · Oelwein, IAAug 28, 1967 · N2646W · Substantial damage NTSB MKC68D0163Accident · No injuriesClosedMooney M20C · Webster City, IAAug 28, 1967 · N78961 · Substantial damage NTSB MKC68D0166Accident · No injuriesClosedCessna 182 · Oskaloosa, IAAug 24, 1967 · N2611G · Substantial damage NTSB MKC68F0185Accident · No injuriesClosedPiper PA-24 · Des Moines, IAAug 23, 1967 · N6001P · Substantial damage NTSB MKC68D0162Accident · No injuriesClosedCessna 182 · George, IAAug 20, 1967 · N2867F · Substantial damage NTSB MKC68D0186Accident · No injuriesClosedPiper PA-11 · Pocahontas, IAAug 19, 1967 · N4985M · Substantial damage NTSB MKC68D0164Accident · Minor injuriesClosedBeech A55 · Harlan, IAAug 18, 1967 · N1590Z · Substantial damage NTSB MKC68F0127Accident · No injuriesClosedPiper PA-32 · Des Moines, IAAug 16, 1967 · N3344W · Substantial damage NTSB MKC68D0504Accident · No injuriesClosedPiper PA-11 · Terril, IAAug 16, 1967 · N5010H · Substantial damage NTSB MKC68D0154Accident · No injuriesClosedPiper PA-30 · Waterloo, IAAug 13, 1967 · N8306Y · Substantial damage NTSB MKC68D0143Accident · No injuriesClosedCessna 182 · Newton, IAAug 13, 1967 · N8540T · Substantial damage NTSB MKC68D0142Accident · No injuriesClosedGlobe GC-1B · Larchwood, IAAug 13, 1967 · N78009 · Substantial damage NTSB MKC68D0136Accident · No injuriesClosedCessna 210 · Sioux City, IAAug 9, 1967 · N9496X · Substantial damage NTSB MKC68F0283Accident · No injuriesClosedCessna 140 · Boone, IAAug 6, 1967 · N1978N · Substantial damage NTSB MKC68D0111Accident · No injuriesClosedCessna 170B · Garnavillo, IAAug 5, 1967 · N4628C · Substantial damage NTSB MKC68F0126Accident · Serious injuriesClosedMooney M20D · Ames, IAAug 3, 1967 · N6631U · Substantial damage NTSB MKC68D0098Accident · No injuriesClosedPiper PA-22 · Des Moines, IAAug 3, 1967 · N4526Z · Substantial damage NTSB MKC68F0083Accident · No injuriesClosedCessna 210 · Ottumwa, IAAug 1, 1967 · N6713R · Substantial damage NTSB MKC68A0008Accident · 1 fatalClosedTaylorcraft BC12-D · Le Mars, IAAug 1, 1967 · N43350 · 2 aircraft · Destroyed NTSB MKC68D0135Accident · No injuriesClosedBeech B35 · Clio, IAJul 27, 1967 · N5120C · Substantial damage NTSB MKC68A0006Accident · No injuriesClosedConvair 340 · Des Moines, IAJul 23, 1967 · N3427 · Substantial damage NTSB MKC68D0080Accident · No injuriesClosedCessna 182 · Oskaloosa, IAJul 15, 1967 · N2611G · 2 aircraft · No damage NTSB MKC68F0082Accident · No injuriesClosedBeech 35 · Newton, IAJul 13, 1967 · N3858N · Substantial damage NTSB MKC68D0079Accident · No injuriesClosedCessna 150 · Cedar Rapids, IAJul 12, 1967 · N8802S · Substantial damage NTSB MKC68D0078Accident · No injuriesClosedPiper PA-18 · Battlecreek, IAJul 10, 1967 · N8972D · Substantial damage NTSB MKC68D0049Accident · Minor injuriesClosedErco 415-C · Clarinda, IAJul 9, 1967 · N3469H · Substantial damage NTSB MKC68D0030Accident · No injuriesClosedMooney M20E · Des Moines, IAJul 7, 1967 · N79331 · Substantial damage NTSB MKC68D0068Accident · No injuriesClosedCessna 182 · Mason City, IAJul 1, 1967 · N3506Y · Substantial damage NTSB MKC68F0048Accident · Serious injuriesClosedCessna 182 · Grimes, IAJun 28, 1967 · N3449F · Substantial damage NTSB MKC68D0069Accident · No injuriesClosedSnow S2C · Clarinda, IAJun 26, 1967 · N1674S · Substantial damage NTSB MKC68F0119Accident · No injuriesClosedLuscombe 8A · Grimes, IAJun 25, 1967 · N1966B · Substantial damage NTSB MKC68A0038Accident · No injuriesClosedBell 47G · Creston, IAJun 25, 1967 · N163B · Substantial damage NTSB MKC68D0084Accident · No injuriesClosedMooney M20E · Sioux City, IAJun 23, 1967 · N5534Q · Substantial damage