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 MKC77DCD03Accident · No injuriesClosedCessna 120 · Forest City, IANov 14, 1976 · N388R · Substantial damage NTSB MKC77DCD02Accident · No injuriesClosedCessna 210 · Modale, IANov 13, 1976 · N5851F · Substantial damage NTSB MKC77DCD01Accident · No injuriesClosedCessna 195B · Tripoli, IAOct 23, 1976 · N2173C · Substantial damage NTSB MKC76DCD67Accident · No injuriesClosedPiper PA-22 · Marion, IASep 17, 1976 · N87760 · Substantial damage NTSB MKC76FCD66Accident · Serious injuriesClosedAeronca 7AC · Prairieburg, IASep 5, 1976 · N81486 · Substantial damage NTSB MKC76DCD65Accident · Minor injuriesClosedTaylorcraft BC12-D · Springville, IAAug 27, 1976 · N95719 · Substantial damage NTSB MKC76FCD64Accident · No injuriesClosedBeech B24R · Lamoni, IAAug 24, 1976 · N48SS · Substantial damage NTSB MKC76FCD63Accident · Serious injuriesClosedPiper PA-25 · Rembranot, IAAug 10, 1976 · N8828L · Destroyed NTSB MKC76DCD62Accident · No injuriesClosedCessna 170B · Council Bluffs, IAAug 3, 1976 · N3253A · Substantial damage NTSB MKC76DCD61Accident · No injuriesClosedPiper PA-28 · Jefferson, IAAug 3, 1976 · N5746F · Substantial damage NTSB MKC76DCD59Accident · No injuriesClosedCessna 150 · Leighton, IAAug 1, 1976 · N19153 · Substantial damage NTSB MKC76FCD60Accident · No injuriesClosedBell 47G-2 · Oskaloosa, IAJul 29, 1976 · N12412 · Substantial damage NTSB MKC76FCD58Accident · No injuriesClosedHughes 269C · Clutier, IAJul 23, 1976 · N9580F · Substantial damage NTSB MKC76AK068Accident · 2 fatalClosedPiper PA-28 · Hiawatha, IAJul 22, 1976 · N6381J · Destroyed NTSB MKC76DCD57Accident · No injuriesClosedCessna 170B · Salix, IAJul 18, 1976 · N1856C · Substantial damage NTSB MKC76AK066Accident · 1 fatalClosedCessna 140 · Lake Mills, IAJul 10, 1976 · N89103 · Destroyed NTSB MKC76FCD55Accident · 1 fatalClosedAcroduster 1 · Council Bluffs, IAJul 4, 1976 · N91FF · Destroyed NTSB MKC76DCD52Accident · No injuriesClosedPiper PA-25 · Tipton, IAJul 1, 1976 · N7089Z · Substantial damage NTSB MKC76FCD53Accident · No injuriesClosedMooney M20G · Melvin, IAJun 28, 1976 · N6765N · Substantial damage NTSB MKC76FCD51Accident · Serious injuriesClosedPiper PA-28 · Cedar Falls, IAJun 27, 1976 · N41642 · Destroyed NTSB MKC76FCD50Accident · No injuriesClosedCessna T210 · Iowa Falls, IAJun 27, 1976 · N1675X · 2 aircraft · Substantial damage NTSB MKC76DCD54Accident · No injuriesClosedBell 47J-2A · Keokuk, IAJun 27, 1976 · N8523F · Substantial damage NTSB MKC76DCD56Accident · No injuriesClosedPiper PA-28 · Cherokee, IAJun 23, 1976 · N461CT · Substantial damage NTSB MKC76DCD49Accident · No injuriesClosedPiper PA-22 · Larchwood, IAJun 13, 1976 · N5933D · Substantial damage NTSB MKC76DCD48Accident · No injuriesClosedPiper PA-28 · Algona, IAJun 8, 1976 · N8066W · Substantial damage NTSB MKC76FCD47Accident · No injuriesClosedHiller Acft UH-12D · Dallas Center, IAJun 6, 1976 · N79SW · Destroyed NTSB MKC76FCD46Accident · No injuriesClosedPiper PA-28 · New Vienna, IAMay 30, 1976 · N5734F · Substantial damage NTSB MKC76DCD45Accident · No injuriesClosedCessna 175 · Oelwein, IAMay 30, 1976 · N6782E · Substantial damage NTSB MKC76DCD44Accident · No injuriesClosedCessna 150J · Muscatine, IAMay 27, 1976 · N51183 · Substantial damage NTSB MKC76FCD43Accident · Minor injuriesClosedCessna 150M · Perry, IAMay 20, 1976 · N7925U · Substantial damage NTSB MKC76DCD42Accident · No injuriesClosedCessna 188 · Cedar Falls, IAMay 18, 1976 · N9735G · Substantial damage NTSB MKC76FCD41Accident · Minor injuriesClosedRaven RX-6 · Carlisle, IAApr 29, 1976 · N8671L · Destroyed NTSB MKC76FCD40Accident · Minor injuriesClosedBrantley B-2B · Marshalltown, IAApr 27, 1976 · N5987X · Destroyed NTSB MKC76FCD39Accident · No injuriesClosedCessna 172C · Orchard, IAApr 18, 1976 · N8440X · Substantial damage NTSB MKC76FCD37Accident · 1 fatalClosedTecumseh Spec · Madrid, IAApr 11, 1976 · N200AM · Destroyed NTSB MKC76AK053Accident · 3 fatalClosedPiper PA-24 · Decorah, IAApr 10, 1976 · N8749P · Destroyed NTSB MKC76DCD38Accident · No injuriesClosedCessna 172 · Council Bluffs, IAApr 8, 1976 · N84412 · Substantial damage NTSB MKC76FCD36Accident · No injuriesClosedPiper PA-24 · Eagle Grove, IAApr 4, 1976 · N7935P · Substantial damage NTSB MKC76DCD35Accident · No injuriesClosedPiper PA-28 · Castalia, IAMar 28, 1976 · N4203J · Substantial damage NTSB MKC76DCD34Accident · No injuriesClosedPiper PA-22 · Hartley, IAMar 20, 1976 · N5728D · Substantial damage NTSB MKC76FCD33Accident · No injuriesClosedPitts S-1S · Harlan, IAMar 18, 1976 · N1115M · Substantial damage NTSB MKC76FCD31Accident · No injuriesClosedBell 47G-2 · Dows, IAMar 17, 1976 · N90529 · Destroyed NTSB MKC76DCD32Accident · No injuriesClosedBeech H35 · Des Moines, IAMar 17, 1976 · N356B · Substantial damage NTSB MKC76AK046Accident · 4 fatalClosedCessna 336 · Mcgregor, IAMar 11, 1976 · N1787Z · Destroyed NTSB MKC76FCD30Accident · No injuriesClosedBeech P35 · Mapleton, IAFeb 25, 1976 · N7117A · Substantial damage NTSB MKC76FCD29Accident · No injuriesClosedPiper PA-28 · Adel, IAFeb 19, 1976 · N1472X · Substantial damage NTSB MKC76FCD28Accident · Serious injuriesClosedCessna 172F · Iowa City, IAFeb 18, 1976 · N8733U · Destroyed NTSB MKC76FCD27Accident · Minor injuriesClosedCessna 150 · Davenport, IAFeb 17, 1976 · N3448J · Destroyed NTSB MKC76FCD25Accident · Serious injuriesClosedCessna 182B · Nevada, IAFeb 7, 1976 · N7222E · Destroyed NTSB MKC76DCD26Accident · No injuriesClosedCessna 150L · New Sharon, IAFeb 7, 1976 · N16132 · Substantial damage