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 MKC78DCD40Accident · No injuriesClosedCessna 170B · Mason City, IAJul 28, 1978 · N2757D · Substantial damage NTSB CHI78IA050Incident · No injuriesClosedBoeing 727 · Lamoni, IAJul 15, 1978 · N7409U · No damage NTSB MKC78FCD39Accident · 2 fatalClosedSkylark WC-3 · Eagle Grove, IAJul 10, 1978 · N214JC · Destroyed NTSB MKC78DCD37Accident · No injuriesClosedCessna 152 · Emmetsburg, IAJul 6, 1978 · N49154 · Substantial damage NTSB MKC78DCD38Accident · No injuriesClosedPiper PA-36 · Steamboat Rock, IAJul 5, 1978 · N57703 · Destroyed NTSB MKC78FCD36Accident · No injuriesClosedPiper PA-23 · Olin, IAJul 2, 1978 · N21CG · Substantial damage NTSB MKC78FA053Accident · 4 fatalClosedPiper PA-32 · Denison, IAJul 1, 1978 · N5510J · Destroyed NTSB MKC78DCD35Accident · Minor injuriesClosedPiper PA-28 · Paullina, IAJun 27, 1978 · N5276S · Substantial damage NTSB MKC78DCD34Accident · No injuriesClosedBell 47J-2 · Burlington, IAJun 18, 1978 · N23MA · Destroyed NTSB MKC78FCD33Accident · No injuriesClosedPiper PA-28 · Washington, IAJun 4, 1978 · N8835N · Substantial damage NTSB MKC78DCD32Accident · No injuriesClosedStarduster 11 · Davenport, IAJun 4, 1978 · N50JB · Substantial damage NTSB MKC78FA033Accident · 1 fatalClosedBellanca 8KCAB · Council Bluffs, IAJun 2, 1978 · N57463 · Destroyed NTSB MKC78DCD30Accident · No injuriesClosedCessna 188 · Atlantic, IAMay 31, 1978 · N9921G · Substantial damage NTSB MKC78FCD31Accident · No injuriesClosedPiper PA-28R · Iowa City, IAMay 30, 1978 · N2895T · Substantial damage NTSB MKC78FCD29Accident · Minor injuriesClosedGrumman AA-5 · Goldfield, IAMay 28, 1978 · N7135L · Substantial damage NTSB MKC78FCD28Accident · Minor injuriesClosedJungster 1 · Monticello, IAMay 24, 1978 · N47M · Substantial damage NTSB MKC78FCD27Accident · No injuriesClosedPiper PA-28 · Anamosa, IAMay 24, 1978 · N5192W · Substantial damage NTSB MKC78FCD26Accident · No injuriesClosedCessna 150 · Ladora, IAMay 24, 1978 · N16117 · Substantial damage NTSB MKC78FCD25Accident · Serious injuriesClosedPiper PA-11 · Terril, IAMay 23, 1978 · N78615 · Substantial damage NTSB MKC79FCD24Accident · No injuriesClosedCampbell KR-1 · Boone, IAMay 20, 1978 · N21KC · Substantial damage NTSB MKC78FCD23Accident · Serious injuriesClosedCessna 150L · Des Moines, IAMay 12, 1978 · N11474 · Substantial damage NTSB MKC78FCD22Accident · No injuriesClosedCessna 402B · Keokuk, IAMay 11, 1978 · N44NC · Substantial damage NTSB MKC78FCD20Accident · No injuriesClosedCessna 177 · Des Moines, IAMay 10, 1978 · N3158T · Substantial damage NTSB MKC78FCD21Accident · Minor injuriesClosedPiper PA-28 · Fairfield, IAMay 9, 1978 · N1490X · Substantial damage NTSB MKC78FCD19Accident · No injuriesClosedPiper PA-32 · Washington, IAMay 4, 1978 · N2DP · Substantial damage NTSB MKC78FCD18Accident · No injuriesClosedLuscombe 8A · 0ttumwa, IAMay 2, 1978 · N1282B · Substantial damage NTSB MKC78FA034Accident · 5 fatalClosedBeech S-35 · Audubon, IAApr 29, 1978 · N7971K · Destroyed NTSB MKC78DCD17Accident · No injuriesClosedCessna 150 · Cumberland, IAApr 14, 1978 · N714KJ · Substantial damage NTSB MKC78FCD16Accident · No injuriesClosedPiper PA-28 · Bedford, IAApr 13, 1978 · N5812W · Substantial damage NTSB MKC78FCD14Accident · No injuriesClosedCessna 175A · Mason City, IAMar 21, 1978 · N111JJ · Substantial damage NTSB MKC78FA030Accident · No injuriesClosedConvair 340 · Elma, IAMar 21, 1978 · N4807C · Destroyed NTSB MKC78DCD13Accident · No injuriesClosedCessna A185F · Muscatine, IAMar 1, 1978 · N2045Q · Substantial damage NTSB MKC78IA023Incident · No injuriesClosedPiper PA-23 · Marshalltown, IAFeb 22, 1978 · N88SS · Minor damage NTSB MKC78DCD12Accident · No injuriesClosedCessna 152 · Ankeny, IAFeb 18, 1978 · N24374 · Substantial damage NTSB MKC78DCD11Accident · No injuriesClosedBeech A24 · Des Moines, IAFeb 15, 1978 · N6927Q · Substantial damage NTSB MKC78DCD15Accident · No injuriesClosedCessna 140 · Shenandoah, IAJan 28, 1978 · N72750 · Substantial damage NTSB MKC78FA020Accident · 3 fatalClosedPiper PA-22 · Tama, IAJan 15, 1978 · N6819B · Destroyed NTSB MKC78DA019Accident · No injuriesClosedCessna 310R · Muscatine, IAJan 12, 1978 · N5080J · Substantial damage NTSB MKC78DCD10Accident · Minor injuriesClosedCessna 150 · Tipton, IADec 22, 1977 · N66055 · Substantial damage NTSB MKC78FA014Accident · 1 fatalClosedPiper PA-28R · Waukon, IADec 16, 1977 · N44988 · Destroyed NTSB MKC78FA013Accident · 2 fatalClosedPiper PA-34 · Davenport, IADec 14, 1977 · N1634H · Destroyed NTSB MKC78FA008Accident · 2 fatalClosedBellanca 8KCAB · Inwood, IANov 28, 1977 · N12PG · Destroyed NTSB MKC78FCD09Accident · Minor injuriesClosedPiper PA-31T · Des Moines, IAOct 26, 1977 · N35RT · Substantial damage NTSB MKC78FCD08Accident · Serious injuriesClosedCessna 172M · Lamoni, IAOct 21, 1977 · N21210 · Substantial damage NTSB MKC78FCD06Accident · No injuriesClosedCessna 140 · Ankeny, IAOct 19, 1977 · N2419V · Substantial damage NTSB MKC78DCD07Accident · Minor injuriesClosedCessna 150 · Des Moines, IAOct 14, 1977 · N714EF · Substantial damage NTSB MKC78FCD03Accident · Serious injuriesClosedRyan Navion · Moulton, IAOct 13, 1977 · N4801K · Destroyed NTSB MKC78DCD04Accident · Minor injuriesClosedErco 415C · Alton, IAOct 13, 1977 · N87272 · Substantial damage NTSB MKC78DCD01Accident · No injuriesClosedBeech B33 · Des Moines, IAOct 5, 1977 · N3EM · Substantial damage NTSB MKC77DCD49Accident · No injuriesClosedPiper PA-12 · Denison, IASep 13, 1977 · N2758M · Substantial damage