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 MKC81DCD24Accident · No injuriesClosedLuscombe 8A · Muscatine, IAJul 12, 1981 · N25346 · Substantial damage NTSB MKC81DCD23Accident · No injuriesClosedThorp T-18 · Waterloo, IAJul 11, 1981 · N179RW · Substantial damage NTSB MKC81DCD22Accident · No injuriesClosedCessna 172D · Laurens, IAJun 22, 1981 · N2406Y · Substantial damage NTSB MKC81DCD21Accident · No injuriesClosedCessna 152 · Arlington, IAJun 20, 1981 · N67606 · Substantial damage NTSB MKC81FCD20Accident · Minor injuriesClosedN American P-51D · Council Bluffs, IAJun 17, 1981 · N5428V · Substantial damage NTSB MKC81FA039Accident · 1 fatalClosedCessna 182 · New Virginia, IAJun 8, 1981 · N9375H · Destroyed NTSB MKC81DCD19Accident · No injuriesClosedPiper PA-28 · Leland, IAMay 27, 1981 · N4431J · Substantial damage NTSB MKC81FA035Accident · No injuriesClosedCessna 421 · Spencer, IAMay 18, 1981 · N1600B · Substantial damage NTSB MKC81FA034Accident · No injuriesClosedPiper PA-32 · Decorah, IAMay 16, 1981 · N2255M · Substantial damage NTSB MKC81FA033Accident · 2 fatalClosedPiper PA-28 · Ottumwa, IAMay 8, 1981 · N2972W · Destroyed NTSB MKC81DCD18Accident · No injuriesClosedPiper PA-32 · Holstein, IAApr 26, 1981 · N2835W · Substantial damage NTSB MKC81FCD17Accident · No injuriesClosedMooney M20J · Norwalk, IAApr 23, 1981 · N4452H · Substantial damage NTSB MKC81IA031Incident · No injuriesClosedPiper PA-32 · St.Ansgar, IAApr 20, 1981 · N3370W · Minor damage NTSB MKC81DCD16Accident · Serious injuriesClosedTaylorcraft BC12-D · Mystic, IAApr 18, 1981 · N96519 · Substantial damage NTSB MKC81DCD15Accident · No injuriesClosedPiper PA-38 · Moulton, IAApr 15, 1981 · N2388D · Destroyed NTSB MKC81FCD14Accident · Serious injuriesClosedMooney M20K · Iowa City, IAApr 9, 1981 · N9766S · Substantial damage NTSB MKC81FA028Accident · 1 fatalClosedPiper PA-28 · Dixon, IAApr 8, 1981 · N47970 · Destroyed NTSB MKC81FA027Accident · 2 fatalClosedPiper PA-28 · Creston, IAApr 8, 1981 · N2250W · Destroyed NTSB MKC81DCD13Accident · No injuriesClosedPiper PA32RT · Waterloo, IAApr 3, 1981 · N36150 · Substantial damage NTSB CHI81DEE25Accident · Minor injuriesClosedCessna 172 · Bellevue, IAApr 1, 1981 · N12119 · Substantial damage NTSB MKC81DCD12Accident · No injuriesClosedPiper PA-24 · Charles City, IAMar 31, 1981 · N6924P · Substantial damage NTSB MKC81FCD11Accident · No injuriesClosedPiper PA-28 · Manson, IAMar 28, 1981 · N5948U · Substantial damage NTSB MKC81FA022Accident · 2 fatalClosedAmer Avco AA-1A · Council Bluffs, IAFeb 25, 1981 · N332A · Destroyed NTSB MKC81DCD10Accident · No injuriesClosedCessna 172 · Spencer, IAFeb 22, 1981 · N7318G · Substantial damage NTSB MKC81FA021Accident · 1 fatalClosedPiper PA-22 · Lohrville, IAFeb 21, 1981 · N3402A · Destroyed NTSB MKC81FA024Accident · No injuriesClosedBeech F33A · Carroll, IAFeb 13, 1981 · N19933 · Substantial damage NTSB MKC81FCD08Accident · No injuriesClosedPiper PA-32R · Cresco, IAFeb 11, 1981 · N1748H · Substantial damage NTSB MKC81FA016Accident · 1 fatalClosedCessna T210 · Laurens, IAJan 31, 1981 · N972JT · Destroyed NTSB MKC81DCD06Accident · No injuriesClosedWilliams Quicki · Newton, IAJan 30, 1981 · N86Q · Substantial damage NTSB MKC81FCD07Accident · No injuriesClosedPiper PA-38 · Cedar Rapids, IAJan 23, 1981 · N2531C · Substantial damage NTSB MKC81FCD05Accident · No injuriesClosedCessna 177RG · Lamoni, IAJan 19, 1981 · N34309 · Substantial damage NTSB MKC81DCD04Accident · No injuriesClosedCessna 180J · Thompson, IADec 23, 1980 · N7510K · Substantial damage NTSB MKC81FA009Accident · 1 fatalClosedCessna 305A · Denison, IANov 29, 1980 · N5262G · Destroyed NTSB MKC81DCD03Accident · No injuriesClosedCessna 180 · Knoxville, IANov 29, 1980 · N9712B · Substantial damage NTSB MKC81FCD02Accident · No injuriesClosedEntrom F-28A · Carson, IANov 23, 1980 · N23HC · Substantial damage NTSB MKC81FCD01Accident · Minor injuriesClosedCessna 120 · La Porte City, IANov 22, 1980 · N77351 · Substantial damage NTSB MKC81FA005Accident · 2 fatalClosedCessna 207 · Cedar Rapids, IAOct 16, 1980 · N91026 · Destroyed NTSB MKC80FCD33Accident · No injuriesClosedHughes 269C · Iowa City, IASep 27, 1980 · N7484F · Substantial damage NTSB MKC80FA051Accident · Minor injuriesClosedIsreal Ind. 1124 · Iowa City, IASep 2, 1980 · N1124P · Substantial damage NTSB MKC80DCD32Accident · No injuriesClosedCessna 182L · Leon, IAAug 30, 1980 · N3182R · Substantial damage NTSB MKC80DCD31Accident · Minor injuriesClosedGrumman G-164 · Hampton, IAAug 30, 1980 · N13MZ · Substantial damage NTSB MKC80FA050Accident · Serious injuriesClosedRallye MS893E · New Virginia, IAAug 19, 1980 · N96088 · Destroyed NTSB MKC80DCD30Accident · No injuriesClosedHughes 269C · Ellsworth, IAAug 14, 1980 · N7480F · Substantial damage NTSB MKC80FCD29Accident · Serious injuriesClosedBellanca 14-13 · Delphus, IAAug 9, 1980 · N744F · Substantial damage NTSB MKC80FA048Accident · 3 fatalClosedPiper PA-28R · Carroll, IAAug 9, 1980 · N47741 · Destroyed NTSB MKC80DCD28Accident · No injuriesClosedBellanca 7ECA · Boone, IAJul 31, 1980 · N5068Y · Substantial damage NTSB MKC80DCD27Accident · No injuriesClosedPiper PA-28R · Humboldt, IAJul 30, 1980 · N2CL · Substantial damage NTSB MKC80DCD24Accident · No injuriesClosedBeech 76 · Sioux City, IAJul 27, 1980 · N6753D · Substantial damage NTSB MKC80FCD23Accident · No injuriesClosedPiper PA-25 · Sprignville, IAJul 24, 1980 · N4927Y · Substantial damage NTSB MKC80FCD22Accident · No injuriesClosedCessna 210 · Waterloo, IAJul 24, 1980 · N5357A · Substantial damage