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 MKC79FCD30Accident · Serious injuriesClosedCessna 177A · Cedar Falls, IAJul 8, 1979 · N30444 · Destroyed NTSB MKC79DCD28Accident · No injuriesClosedBell 47-G2 · Anthon, IAJul 3, 1979 · N85Z · Destroyed NTSB MKC79DCD27Accident · No injuriesClosedGR Lakes 2T-1A2 · Algona, IAJul 1, 1979 · N3812F · Substantial damage NTSB MKC79FCD26Accident · Serious injuriesClosedCessna A188 · Des Moines, IAJun 30, 1979 · N6299G · Destroyed NTSB MKC79FCD25Accident · Serious injuriesClosedCessna 188B · Iowa Falls, IAJun 30, 1979 · N4465Q · Destroyed NTSB MKC79FCD24Accident · No injuriesClosedHughes 269B · Wellman, IAJun 28, 1979 · N9416F · Substantial damage NTSB MKC79DCD23Accident · No injuriesClosedCessna 177 · Oelwein, IAJun 22, 1979 · N34631 · Substantial damage NTSB MKC79FCD22Accident · Minor injuriesClosedNavion B · Mapleton, IAJun 8, 1979 · N5301K · Substantial damage NTSB MKC79FCD21Accident · Minor injuriesClosedGrumman AA-5A · Cedar Rapids, IAJun 6, 1979 · N9814U · Substantial damage NTSB MKC79DCD20Accident · No injuriesClosedErco 415-C · Creston, IAMay 26, 1979 · N2916H · Substantial damage NTSB MKC79DCD19Accident · No injuriesClosedCessna 172 · Sioux Center, IAMay 22, 1979 · N8919B · Substantial damage NTSB MKC79FCD18Accident · No injuriesClosedCessna 172 · Fort Dodge, IAApr 26, 1979 · N734LV · Substantial damage NTSB MKC79FCD16Accident · Minor injuriesClosedMooney M20E · Cresco, IAApr 20, 1979 · N7115U · Substantial damage NTSB MKC79FA026Accident · 2 fatalClosedBeech E18S · Cedar Rapids, IAMar 23, 1979 · N201GW · Destroyed NTSB MKC79FCD15Accident · No injuriesClosedCessna 182Q · Tipton, IAMar 15, 1979 · N759GU · Destroyed NTSB MKC79DCD14Accident · No injuriesClosedBeech 35 · Grinnell, IAMar 14, 1979 · N906B · Substantial damage NTSB MKC79FCD13Accident · No injuriesClosedMooney M-20G · Wellsburg, IAMar 10, 1979 · N3613N · Substantial damage NTSB MKC79FA020Accident · No injuriesClosedPiper PA-31 · Clinton, IAFeb 28, 1979 · N9170Y · Substantial damage NTSB MKC79FCD1ZAccident · No injuriesClosedBeech C-23 · Manchester, IAFeb 26, 1979 · N6008J · Substantial damage NTSB MKC79FA018Accident · Minor injuriesClosedPiper PA-23 · Waterloo, IAFeb 22, 1979 · N14261 · Destroyed NTSB MKC79DCD11Accident · No injuriesClosedCessna 140 · Lamotte, IAFeb 11, 1979 · N89902 · Substantial damage NTSB MKC79DCD09Accident · No injuriesClosedTaylorcraft BC-12D · Nevada, IAJan 7, 1979 · N95622 · Substantial damage NTSB MKC79DCD08Accident · No injuriesClosedCessna 150G · Burlington, IAJan 7, 1979 · N2431J · Substantial damage NTSB MKC79FCD07Accident · No injuriesClosedCessna 310Q · Waverly, IADec 28, 1978 · N728SC · Substantial damage NTSB MKC79FCD06Accident · No injuriesClosedMooney M-20 · Des Moines, IADec 15, 1978 · N6376Q · Substantial damage NTSB MKC79FA009Accident · 2 fatalClosedBrantly B-2B · Sloan, IADec 15, 1978 · N1122K · Destroyed NTSB MKC79FA008Accident · No injuriesClosedLear Jet 35 · Muscatine, IADec 11, 1978 · N20BG · Substantial damage NTSB MKC79FCD04Accident · No injuriesClosedCessna 152 · Muscatine, IADec 10, 1978 · N49159 · Substantial damage NTSB MKC79FA007Accident · Serious injuriesClosedDouglas DC-3 · Des Moines, IADec 2, 1978 · N41447 · Substantial damage NTSB MKC79FCD03Accident · Minor injuriesClosedBellanca 7KCAB · Castalia, IAOct 29, 1978 · N88188 · Destroyed NTSB MKC79DCD02Accident · No injuriesClosedCessna 172 · Williams, IAOct 10, 1978 · N80310 · Substantial damage NTSB MKC79DCD01Accident · No injuriesClosedCessna 150 · Council Bluffs, IAOct 6, 1978 · N66664 · Substantial damage NTSB MKC78DCD57Accident · No injuriesClosedCessna 172 · Jesup, IASep 30, 1978 · N46438 · Substantial damage NTSB MKC78DCD56Accident · No injuriesClosedPiper PA-28 · Allison, IASep 7, 1978 · N7840W · Substantial damage NTSB MKC78DCD55Accident · No injuriesClosedPiper PA-25 · Milford, IASep 7, 1978 · N6447Z · Substantial damage NTSB MKC78DCD54Accident · No injuriesClosedCallair A-9B · Lake Park, IASep 6, 1978 · N7757V · Substantial damage NTSB MKC78FCD52Accident · Serious injuriesClosedCessna 172N · Clinton, IASep 3, 1978 · N734NP · Substantial damage NTSB MKC78FCD51Accident · Serious injuriesClosedCessna 150 · New Albin, IASep 3, 1978 · N3749V · Substantial damage NTSB MKC78FCD50Accident · Minor injuriesClosedHughes 300C · Baxter, IAAug 31, 1978 · N7431F · Substantial damage NTSB MKC78DCD53Accident · No injuriesClosedPiper PA-28 · South English, IAAug 31, 1978 · N3252Q · Substantial damage NTSB MKC78DCD49Accident · No injuriesClosedBell 47G-5A · Manson, IAAug 29, 1978 · N14841 · Substantial damage NTSB MKC78DCD48Accident · Minor injuriesClosedTaylorcraft A · Blakesburg, IAAug 28, 1978 · N19877 · Substantial damage NTSB MKC78DCD47Accident · No injuriesClosedCessna 210M · Davenport, IAAug 28, 1978 · N732LB · Substantial damage NTSB MKC78DCD46Accident · No injuriesClosedPiper PA-32R · Des Moines, IAAug 25, 1978 · N12ML · Substantial damage NTSB MKC78FCD45Accident · No injuriesClosedTravel Air D4D · Des Moines, IAAug 23, 1978 · N434N · Substantial damage NTSB MKC78FCD44Accident · Serious injuriesClosedAeronca 7BCM · Toledo, IAAug 16, 1978 · N83659 · Destroyed NTSB MKC78FA064Accident · 1 fatalClosedGreat Lakes 2T-1A · Mason City, IAAug 12, 1978 · N3801F · Destroyed NTSB MKC78DCD43Accident · Minor injuriesClosedPiper PA-36 · Irving, IAAug 12, 1978 · N44043 · Substantial damage NTSB MKC78DCD41Accident · No injuriesClosedCessna 188B · Yale, IAAug 9, 1978 · N9208R · Substantial damage NTSB MKC78DCD42Accident · Minor injuriesClosedAeronca 7AC · Corning, IAAug 5, 1978 · N83008 · Substantial damage