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 MKC70F0094Accident · Minor injuriesClosedBeech 35 · Logan, IAJun 26, 1969 · N3005V · Substantial damage NTSB MKC70F0015Accident · No injuriesClosedCallair A-9 · Jefferson, IAJun 23, 1969 · N7276V · Substantial damage NTSB MKC70D0031Accident · No injuriesClosedLuscombe 8A · Rock Rapids, IAJun 18, 1969 · N45534 · Substantial damage NTSB MKC70D0044Accident · No injuriesClosedCessna 150 · Woodbine, IAJun 15, 1969 · N8807S · Substantial damage NTSB MKC69F0472Accident · No injuriesClosedCessna 172 · Winterset, IAJun 10, 1969 · N1478F · Substantial damage NTSB MKC70D0013Accident · No injuriesClosedPiper PA-22 · Des Moines, IAJun 8, 1969 · N3739A · Substantial damage NTSB MKC70D0004Accident · No injuriesClosedCessna 180 · Cumming, IAJun 3, 1969 · N2432C · Substantial damage NTSB MKC69D0477Accident · No injuriesClosedPiper PA-28 · Des Moines, IAJun 3, 1969 · N6300J · Substantial damage NTSB MKC69D0476Accident · No injuriesClosedChampion 7ECA · Atlantic, IAMay 31, 1969 · N11051 · Substantial damage NTSB MKC70F0016Accident · No injuriesClosedCessna 310 · Sac City, IAMay 22, 1969 · CF-KUL · Substantial damage NTSB MKC69I0060Incident · No injuriesClosedAero Comdr 500-B · Iowa City, IAMay 22, 1969 · N6308U · No damage NTSB MKC70D0002Accident · No injuriesClosedMooney M20B · Stout, IAMay 19, 1969 · N74765 · Substantial damage NTSB MKC69D0452Accident · No injuriesClosedCessna 150B · Thompson, IAMay 18, 1969 · N7360X · Substantial damage NTSB MKC69D0445Accident · Minor injuriesClosedCessna 177 · Clermont, IAMay 12, 1969 · N2923X · Substantial damage NTSB MKC69F0428Accident · Serious injuriesClosedPiper PA-16 · Adel, IAMay 11, 1969 · N5710H · Destroyed NTSB MKC69F0417Accident · No injuriesClosedCessna 210 · Des Moines, IAMay 1, 1969 · N9699T · Substantial damage NTSB MKC69F0429Accident · No injuriesClosedCessna 177 · Jefferson, IAApr 27, 1969 · N2605Q · Substantial damage NTSB MKC69D0423Accident · Serious injuriesClosedCessna 150 · Irwin, IAApr 27, 1969 · N60064 · Destroyed NTSB MKC69F0414Accident · No injuriesClosedCessna 182 · Monticello, IAApr 18, 1969 · N2580Q · Substantial damage NTSB MKC69D0406Accident · No injuriesClosedPiper PA-22 · Anamosa, IAApr 18, 1969 · N3903P · Substantial damage NTSB MKC69D0400Accident · No injuriesClosedBeech V35 · Sac City, IAApr 7, 1969 · N5727V · Substantial damage NTSB MKC69F0396Accident · No injuriesClosedCessna 150 · Cedar Rapids, IAApr 6, 1969 · N4326U · Substantial damage NTSB MKC69F0397Accident · No injuriesClosedPiper PA-28 · New Liberty, IAMar 19, 1969 · N561CC · Substantial damage NTSB MKC69D0352Accident · No injuriesClosedBeech 19A · Perry, IAMar 16, 1969 · N6066N · Substantial damage NTSB MKC69D0392Accident · No injuriesClosedCessna 150 · Mt.Pleasant, IAMar 15, 1969 · N4028U · Substantial damage NTSB MKC69D0380Accident · No injuriesClosedAeronca 7AC · Osage, IAMar 14, 1969 · N81844 · Substantial damage NTSB MKC69D0374Accident · No injuriesClosedPiper PA-28 · Perry, IAMar 12, 1969 · N4886L · Substantial damage NTSB MKC69F0339Accident · No injuriesClosedPiper PA-28 · Iowa City, IAMar 9, 1969 · N6426W · Substantial damage NTSB MKC69D0361Accident · No injuriesClosedPiper PA-28 · Fort Dodge, IAMar 7, 1969 · N7591R · Substantial damage NTSB MKC69D0359Accident · No injuriesClosedCessna 140 · Emmetsburg, IAMar 7, 1969 · N2320V · Substantial damage NTSB MKC69D0365Accident · No injuriesClosedPiper PA-22 · Ankeny, IAMar 1, 1969 · N1209C · Substantial damage NTSB MKC69D0355Accident · No injuriesClosedPiper PA-22 · Grimes, IAMar 1, 1969 · N7801D · Substantial damage NTSB MKC69F0338Accident · No injuriesClosedCessna 150A · Denison, IAFeb 18, 1969 · N7236X · Substantial damage NTSB MKC69D0346Accident · No injuriesClosedPiper PA-30 · Osceola, IAFeb 10, 1969 · N7243Y · Substantial damage NTSB MKC69F0344Accident · No injuriesClosedPiper PA-32 · Chariton, IAFeb 9, 1969 · N3645W · Substantial damage NTSB MKC69D0350Accident · Minor injuriesClosedPiper PA-25 · Dubuque, IAFeb 7, 1969 · N4352Y · Substantial damage NTSB MKC69D0345Accident · No injuriesClosedPiper J-3 · Plymouth, IAFeb 2, 1969 · N3245N · Substantial damage NTSB MKC69D0339Accident · No injuriesClosedAero Comdr 500-B · Waterloo, IAJan 27, 1969 · N553HH · Substantial damage NTSB MKC69D0316Accident · No injuriesClosedCessna 190 · Osage, IAJan 11, 1969 · N1500D · Substantial damage NTSB MKC69F0317Accident · No injuriesClosedPiper PA-23 · Estherville, IAJan 10, 1969 · N2289P · Substantial damage NTSB MKC69F0315Accident · 1 fatalClosedMooney M20A · Williams, IAJan 5, 1969 · N5531Q · Destroyed NTSB MKC69F0307Accident · No injuriesClosedBeech A35 · Burlington, IAJan 2, 1969 · N8666A · Substantial damage NTSB MKC69F0308Accident · No injuriesClosedCessna 172I · Floris, IADec 31, 1968 · N46242 · Substantial damage NTSB MKC69D0300Accident · No injuriesClosedPiper PA-22 · Nashua, IADec 29, 1968 · N2657P · Substantial damage NTSB MKC69D0327Accident · No injuriesClosedPiper PA-11 · Hampton, IADec 28, 1968 · N4866M · Substantial damage NTSB DCA69A0009Accident · Serious injuriesClosedDouglas DC- 9 · Sioux City, IADec 27, 1968 · N974Z · Destroyed NTSB MKC69F0326Accident · No injuriesClosedPiper PA-23 · Creston, IADec 26, 1968 · N3341P · Substantial damage NTSB MKC69D0290Accident · No injuriesClosedCessna 170B · Oakland, IADec 9, 1968 · N4581C · Substantial damage NTSB MKC69D0285Accident · No injuriesClosedCessna 310 · Estherville, IADec 6, 1968 · N3688D · Substantial damage NTSB MKC69D0286Accident · No injuriesClosedCessna 172 · Charles City, IADec 5, 1968 · N1769F · Substantial damage