Skip to content

NTSB investigations, IA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MKC80FCD21Accident · No injuriesClosedHughes 269C · Council Bluffs, IAJul 23, 1980 · N8644F · Substantial damage NTSB MKC80FA047Accident · 1 fatalClosedPitts S1 · Centerville, IAJul 22, 1980 · N1012S · Destroyed NTSB MKC80FCD26Accident · No injuriesClosedCessna 152 · Ames, IAJul 19, 1980 · N4793B · Substantial damage NTSB MKC80FCD25Accident · No injuriesClosedCessna U206 · Burlington, IAJul 17, 1980 · N7562N · Substantial damage NTSB MKC80FA043Accident · Serious injuriesClosedCessna 401A · Spirit Lake, IAJul 11, 1980 · N3249Q · Destroyed NTSB MKC80FCD20Accident · No injuriesClosedCessna 182Q · Milford, IAJul 10, 1980 · N759RC · Substantial damage NTSB MKC80DCD19Accident · No injuriesClosedMooney M20F · Ft.Dodge, IAJul 7, 1980 · N6397Q · Substantial damage NTSB MKC80FCD18Accident · No injuriesClosedBeech 95-D55 · Mason City, IAJun 13, 1980 · N7952R · Substantial damage NTSB MKC80FCD17Accident · No injuriesClosedBoeing A75 · Sioux City, IAJun 8, 1980 · N5568V · Substantial damage NTSB MKC80FCD16Accident · Minor injuriesClosedPiper J3C-65 · Danville, IAMay 29, 1980 · N9814 · Substantial damage NTSB MKC80DA033Accident · Serious injuriesClosedRaven S55A · Council Bluffs, IAMay 3, 1980 · N1089R · Substantial damage NTSB MKC80DA032Accident · No injuriesClosedBeech 18S · Cedar Rapids, IAApr 24, 1980 · N166H · Substantial damage NTSB MKC80FCD15Accident · Minor injuriesClosedMcculley Quicki · Muscatine, IAApr 17, 1980 · N9038Z · Substantial damage NTSB MKC80FCD14Accident · Serious injuriesClosedCessna 210L · Clear Lake, IAApr 2, 1980 · N59168 · Substantial damage NTSB MKC80AA026Accident · 3 fatalClosedAerospatle AS350D · Webster City, IAMar 3, 1980 · N353RM · Destroyed NTSB MKC80FA024Accident · 2 fatalClosedGrum-Amer AA-5B · Spencer, IAFeb 21, 1980 · N74028 · Destroyed NTSB MKC80FCD13Accident · Minor injuriesClosedBeech E33A · Carroll, IAFeb 20, 1980 · N29880 · Substantial damage NTSB MKC80FA022Accident · Serious injuriesClosedBeech A35 · Creston, IAFeb 14, 1980 · N71RT · Destroyed NTSB MKC80FCD12Accident · No injuriesClosedCessna 185 · Creston, IAFeb 7, 1980 · N7377H · Substantial damage NTSB MKC80FCD11Accident · No injuriesClosedPiper PA-28R · Ankeny, IAJan 27, 1980 · N57305 · Substantial damage NTSB MKC80FA019Accident · 4 fatalClosedPiper PA-28 · Clare, IAJan 25, 1980 · N9421C · Destroyed NTSB MKC80DCD10Accident · No injuriesClosedCessna U206 · West Union, IAJan 11, 1980 · N733WF · Substantial damage NTSB MKC80FCD09Accident · No injuriesClosedCessna 177RG · Greenfield, IADec 22, 1979 · N52195 · Substantial damage NTSB MKC80FCD08Accident · No injuriesClosedCessna 150 · Maquoketa, IADec 9, 1979 · N16129 · Substantial damage NTSB MKC80FA012Accident · No injuriesClosedAerospatle 319B · Baxter, IADec 7, 1979 · N90825 · Substantial damage NTSB MKC80FCD07Accident · No injuriesClosedBeech C35 · Somers, IANov 30, 1979 · N8976A · Substantial damage NTSB UNK80X0102Accident · 1 fatalClosedPiper PA-28 · Melvin, IANov 11, 1979 · N2181D · Destroyed NTSB MKC80FCD06Accident · No injuriesClosedLuscombe 8A · Winterset, IANov 4, 1979 · N41961 · Substantial damage NTSB MKC80FCD04Accident · No injuriesClosedPiper PA-22 · Des Moines, IAOct 28, 1979 · N8731C · Substantial damage NTSB MKC80DCD05Accident · No injuriesClosedPiper PA-22 · Des Moines, IAOct 27, 1979 · N8194C · 2 aircraft · Substantial damage NTSB MKC80DCD03Accident · No injuriesClosedPiper PA-28 · Oelwein, IAOct 24, 1979 · N538FL · Substantial damage NTSB MKC80DCD02Accident · No injuriesClosedAeronca 7AC · Lamotte, IAOct 17, 1979 · N83589 · Substantial damage NTSB MKC80DCD01Accident · No injuriesClosedCessna 150 · New Hampton, IAOct 7, 1979 · N5937J · Substantial damage NTSB MKC79DCD44Accident · No injuriesClosedPiper PA-25 · Lost Nation, IASep 30, 1979 · N4957Y · Destroyed NTSB MKC79DCD43Accident · No injuriesClosedPiper PA-28 · Wever, IASep 29, 1979 · N5556F · Substantial damage NTSB MKC79DCD42Accident · No injuriesClosedCessna 182P · Kossuth, IASep 27, 1979 · N7337Q · Substantial damage NTSB MKC79FCD45Accident · Minor injuriesClosedPiper J-3 · Madrid, IASep 25, 1979 · N98602 · Substantial damage NTSB MKC79FCD41Accident · Serious injuriesClosedBell 47G-3B · Pierson, IASep 25, 1979 · N8471E · Substantial damage NTSB MKC79DCD40Accident · No injuriesClosedCessna 152 · Oxford, IASep 12, 1979 · N65465 · Substantial damage NTSB MKC79DCD38Accident · No injuriesClosedMooney M20C · Waverly, IASep 9, 1979 · N6419U · Substantial damage NTSB MKC79DCD37Accident · No injuriesClosedPiper PA-36 · Manning, IASep 7, 1979 · N3881E · Substantial damage NTSB MKC79DCD36Accident · No injuriesClosedGrumman G-164 · Masonville, IAAug 29, 1979 · N13MZ · Destroyed NTSB MKC79DCD34Accident · No injuriesClosedLuscombe 8E · Oskaloosa, IAAug 28, 1979 · N2518K · Substantial damage NTSB MKC79DCD35Accident · No injuriesClosedCessna 152 · Mt Pleasant, IAAug 27, 1979 · N24366 · Substantial damage NTSB MKC79DCD39Accident · No injuriesClosedCessna 172B · Council Bluffs, IAAug 20, 1979 · N7521X · Substantial damage NTSB MKC79FCD33Accident · Serious injuriesClosedCessna 210 · Fostoria, IAAug 19, 1979 · N732WZ · Destroyed NTSB MKC79DCD32Accident · Minor injuriesClosedPiper PA-28 · Davenport, IAAug 17, 1979 · N4360F · Substantial damage NTSB MKC79FA043Accident · 1 fatalClosedCessna 150F · Independence, IAJul 26, 1979 · N6879F · Destroyed NTSB MKC79DCD31Accident · No injuriesClosedCessna 180 · Lawton, IAJul 14, 1979 · N4626B · Substantial damage NTSB MKC79DCD29Accident · No injuriesClosedPiper PA-38 · Ladora, IAJul 10, 1979 · N2313A · Substantial damage