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 MKC70DCD18Accident · No injuriesClosedPiper PA-18 · Clarinda, IADec 8, 1969 · N1387A · Substantial damage NTSB MKC70D0288Accident · No injuriesClosedCessna 170B · Holstein, IADec 1, 1969 · N2356D · Substantial damage NTSB MKC70D0280Accident · No injuriesClosedPiper PA-22 · Quasqueton, IANov 30, 1969 · N9431D · Substantial damage NTSB MKC70D0289Accident · No injuriesClosedPiper PA-28 · Creston, IANov 26, 1969 · N4139J · Substantial damage NTSB MKC70A0029Accident · 1 fatalClosedChampion 7ECA · Royal, IANov 25, 1969 · N9634S · Destroyed NTSB MKC70F0278Accident · Serious injuriesClosedAeronca 7AC · Harlan, IANov 23, 1969 · N84331 · Destroyed NTSB MKC70F0281Accident · Serious injuriesClosedCessna 120 · Riverton, IANov 15, 1969 · N1878N · Destroyed NTSB MKC70D0264Accident · No injuriesClosedPiper PA-28R · Muscatine, IANov 9, 1969 · N4696J · Substantial damage NTSB MKC70D0242Accident · No injuriesClosedCessna 150J · Waterloo, IAOct 26, 1969 · N50473 · Substantial damage NTSB MKC70D0234Accident · No injuriesClosedPiper PA-23 · Des Moines, IAOct 13, 1969 · N6385Y · Substantial damage NTSB MKC70F0230Accident · No injuriesClosedBeech V35 · Dows, IAOct 5, 1969 · N563DB · Substantial damage NTSB MKC70A0020Accident · Serious injuriesClosedCessna 402A · Decorah, IAOct 2, 1969 · N4554Q · No damage NTSB MKC70A0014Accident · 2 fatalClosedCessna 140 · Hartley, IAOct 1, 1969 · N1984V · Destroyed NTSB MKC70F0218Accident · No injuriesClosedPiper PA-22 · Cedar Falls, IASep 27, 1969 · N5970Z · Substantial damage NTSB MKC70D0236Accident · Minor injuriesClosedCessna 150 · Council Bluf, IASep 21, 1969 · N2846S · Substantial damage NTSB MKC70F0217Accident · No injuriesClosedPiper PA-32 · Carroll, IASep 19, 1969 · N5540J · Substantial damage NTSB MKC70D0215Accident · No injuriesClosedCessna 177 · Des Moines, IASep 17, 1969 · N3499T · Substantial damage NTSB MKC70F0216Accident · No injuriesClosedCessna 177 · Polk City, IASep 13, 1969 · N29490 · Substantial damage NTSB MKC70F018OAccident · Serious injuriesClosedBreezy 17A · Washington, IASep 10, 1969 · N1683 · Minor damage NTSB MKC70D0206Accident · No injuriesClosedPiper PA-18 · West Liberty, IASep 7, 1969 · N3838Z · Substantial damage NTSB MKC70D0199Accident · Minor injuriesClosedRose A M A-1 · Ottumwa, IASep 7, 1969 · N14843 · Substantial damage NTSB MKC70F0192Accident · 1 fatalClosedCallair A9 · Yale, IASep 3, 1969 · N7276V · Destroyed NTSB MKC70D0185Accident · No injuriesClosedCallair A-9 · Greattinger, IASep 1, 1969 · N7240V · Destroyed NTSB MKC70D0173Accident · Minor injuriesClosedCessna 150 · Council Blfs, IAAug 31, 1969 · N8547G · Substantial damage NTSB MKC70A0008Accident · 3 fatalClosedCessna 172H · Newton, IAAug 31, 1969 · N3149X · Destroyed NTSB MKC70F0153Accident · No injuriesClosedRose A-M A-1 · Ottumwa, IAAug 30, 1969 · N18252 · 2 aircraft · Substantial damage NTSB MKC70D0235Accident · No injuriesClosedPiper PA-28 · Guttenberg, IAAug 29, 1969 · N7235W · Substantial damage NTSB MKC70D0149Accident · No injuriesClosedFournier RF-4D · Pella, IAAug 28, 1969 · N7752 · Substantial damage NTSB MKC70F0191Accident · 1 fatalClosedPiper PA-18A · Gillett Grve, IAAug 26, 1969 · N9901D · Destroyed NTSB MKC70D0204Accident · No injuriesClosedBell 47G-5 · Irwin, IAAug 26, 1969 · N7801S · Substantial damage NTSB MKC70D0157Accident · No injuriesClosedCessna 177 · Marshallton, IAAug 25, 1969 · N2295Y · Substantial damage NTSB MKC70D0224Accident · No injuriesClosedCessna 172 · Missouri Val, IAAug 24, 1969 · N5806R · Substantial damage NTSB MKC70D0147Accident · No injuriesClosedBeech S35 · Spirit Lake, IAAug 23, 1969 · N171H · Substantial damage NTSB MKC70D0162Accident · No injuriesClosedBeech B35 · Clinton, IAAug 17, 1969 · N3399V · Substantial damage NTSB MKC70I0141Incident · No injuriesClosedBeech B95A · Oskaloosa, IAAug 12, 1969 · N9697Y · Minor damage NTSB MKC70D0144Accident · No injuriesClosedStinson 108-3 · Mcgregor, IAAug 12, 1969 · N6427M · Substantial damage NTSB MKC70D0142Accident · No injuriesClosedBeech 35-B33 · Grinnell, IAAug 11, 1969 · N9703Y · Substantial damage NTSB MKC70D0131Accident · No injuriesClosedPiper PA-24 · Laporte City, IAAug 8, 1969 · N7481P · Substantial damage NTSB MKC70D0105Accident · No injuriesClosedCessna 150 · Davenport, IAAug 6, 1969 · N8613S · Substantial damage NTSB MKC70D0123Accident · No injuriesClosedPiper PA-28 · Sac City, IAAug 5, 1969 · N5497W · Substantial damage NTSB MKC70D0143Accident · No injuriesClosedBoeing A75 · Hawarden, IAJul 29, 1969 · N54545 · Substantial damage NTSB MKC70D0139Accident · No injuriesClosedPiper PA-28 · Atlantic, IAJul 26, 1969 · N8243N · Substantial damage NTSB MKC70D0104Accident · No injuriesClosedPiper PA-28 · Epworth, IAJul 24, 1969 · N4839L · Substantial damage NTSB MKC70F0096Accident · Serious injuriesClosedPiper PA-23 · Newton, IAJul 22, 1969 · N5246Y · Destroyed NTSB MKC70D0068Accident · No injuriesClosedCessna 150J · Polk City, IAJul 15, 1969 · N50588 · Substantial damage NTSB MKC70D0111Accident · No injuriesClosedPiper PA-32 · Eagle Grove, IAJul 10, 1969 · N3805W · Substantial damage NTSB MKC70D0050Accident · No injuriesClosedRyan ST-A · Ackley, IAJul 7, 1969 · N17352 · Substantial damage NTSB MKC70F0040Accident · No injuriesClosedBeech A23 · Cedar Rapids, IAJul 2, 1969 · N8857M · Substantial damage NTSB MKC70D0055Accident · No injuriesClosedTaylorcraft BC12-D · Grinnell, IAJun 29, 1969 · N95254 · Substantial damage NTSB MKC70F0039Accident · No injuriesClosedDouglas B-26C · Ames, IAJun 28, 1969 · N91356 · Substantial damage