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 MKC68D0593Accident · No injuriesClosedCessna 120 · Dallas Ctr., IAMay 21, 1968 · N72715 · Substantial damage NTSB MKC68D0586Accident · No injuriesClosedPiper PA-28 · Mount Vernon, IAMay 17, 1968 · N5172L · Substantial damage NTSB OAK68A0067Accident · Serious injuriesClosedBoeing 720B · Mason City, IAMay 13, 1968 · N7549AA · No damage NTSB MKC68F0546Accident · No injuriesClosedBeech S35 · Knoxville, IAMay 13, 1968 · N5660K · Substantial damage NTSB MKC68F0549Accident · No injuriesClosedPiper PA-23 · Des Moines, IAMay 10, 1968 · N4040P · Substantial damage NTSB MKC68F0547Accident · Minor injuriesClosedPiper PA-22 · Forest City, IAMay 8, 1968 · N8047C · Destroyed NTSB MKC68D0555Accident · Minor injuriesClosedCessna 150 · St.Paul, IAMay 5, 1968 · N4030J · Substantial damage NTSB MKC68D0543Accident · No injuriesClosedCessna 172 · Jefferson, IAApr 30, 1968 · N7474A · Substantial damage NTSB MKC68D0563Accident · No injuriesClosedCessna 172 · Keokuk, IAApr 28, 1968 · N35344 · Substantial damage NTSB MKC68F0526Accident · Minor injuriesClosedPiper PA-22 · Lynnville, IAApr 27, 1968 · N3401A · Substantial damage NTSB MKC68F0514Accident · No injuriesClosedBeech F35 · Des Moines, IAApr 23, 1968 · N4244B · Substantial damage NTSB MKC68F0559Accident · Serious injuriesClosedPiper PA-23 · Thornton, IAApr 22, 1968 · N3287P · Destroyed NTSB MKC68D0524Accident · No injuriesClosedCessna 206 · Shenandoah, IAApr 13, 1968 · N5244U · Substantial damage NTSB MKC68D0517Accident · No injuriesClosedBeech A23-24 · Leon, IAApr 12, 1968 · N7907L · Substantial damage NTSB MKC68A0060Accident · No injuriesClosedCessna 182 · Shenandoah, IAApr 12, 1968 · N3347R · Substantial damage NTSB MKC68D0516Accident · No injuriesClosedPiper PA-28 · Storm Lake, IAApr 11, 1968 · N8949J · Substantial damage NTSB MKC68D0552Accident · No injuriesClosedBeech A23 · Dubuque, IAApr 9, 1968 · N1418L · Substantial damage NTSB MKC68D0518Accident · No injuriesClosedCessna 172 · Chariton, IAMar 23, 1968 · N1647Y · Substantial damage NTSB MKC68D0486Accident · No injuriesClosedCessna 177 · Mt Ayr, IAMar 16, 1968 · N2605Q · Substantial damage NTSB MKC68D0477Accident · No injuriesClosedPiper PA-28 · Ogden, IAMar 8, 1968 · N9971J · Substantial damage NTSB MKC68D0479Accident · No injuriesClosedPiper PA-22 · Marshalltown, IAMar 3, 1968 · N8807D · Substantial damage NTSB CHI68D0623Accident · No injuriesClosedCessna 177 · Dodgeville, IAFeb 23, 1968 · N2363Y · Substantial damage NTSB MKC68D0464Accident · No injuriesClosedPiper PA-32 · Denison, IAFeb 20, 1968 · N3447W · Substantial damage NTSB MKC68A0054Accident · 1 fatalClosedBensen B8M · West Liberty, IAFeb 19, 1968 · N5315 · Destroyed NTSB MKC68D0444Accident · No injuriesClosedCessna 172F · Indianola, IAFeb 16, 1968 · N8272U · Destroyed NTSB MKC68A0052Accident · Serious injuriesClosedCessna P206A · Fort Madison, IAFeb 12, 1968 · N4653F · Substantial damage NTSB MKC68A0049Accident · No injuriesClosedBell 47G · Onawa, IAFeb 6, 1968 · N970B · Destroyed NTSB MKC68D0439Accident · Minor injuriesClosedCessna 150G · Dubuque, IAJan 30, 1968 · N3954J · Substantial damage NTSB MKC68D0437Accident · No injuriesClosedPiper PA-28 · Fairfield, IAJan 26, 1968 · N8423R · Substantial damage NTSB MKC68F0395Accident · No injuriesClosedStinson 10 · Grimes, IADec 28, 1967 · N26290 · Substantial damage NTSB MKC68D0399Accident · No injuriesClosedCessna 172E · Agency, IADec 28, 1967 · N3684S · Substantial damage NTSB MKC68A0042Accident · No injuriesClosedCessna 210 · Ute, IADec 28, 1967 · N3672Y · Substantial damage NTSB MKC68D0397Accident · No injuriesClosedPiper PA-22 · Forest City, IADec 24, 1967 · N2655A · Substantial damage NTSB MKC68D0372Accident · No injuriesClosedPiper PA-22 · Marshalltown, IADec 16, 1967 · N6724B · Substantial damage NTSB MKC68F0420Accident · Minor injuriesClosedBeech 65-A90 · Iowa City, IADec 12, 1967 · N772K · Substantial damage NTSB MKC68D0373Accident · No injuriesClosedPiper PA-28 · Iowa City, IADec 12, 1967 · N6426W · Substantial damage NTSB MKC68F0386Accident · Serious injuriesClosedMooney M20E · Mt.Pleasant, IADec 6, 1967 · N1386W · Destroyed NTSB MKC68A0036Accident · 3 fatalClosedMooney M20C · Davenport, IADec 3, 1967 · N5940Q · Destroyed NTSB MKC68F0367Accident · No injuriesClosedCessna 310L · Des Moines, IANov 26, 1967 · N2233F · Substantial damage NTSB MKC68F0362Accident · Minor injuriesClosedPiper PA-22 · Ralston, IANov 26, 1967 · N947A · Destroyed NTSB MKC68D0328Accident · No injuriesClosedCessna 150 · Washington, IANov 17, 1967 · N7799F · Substantial damage NTSB MKC68D0394Accident · No injuriesClosedPiper PA-28 · Davenport, IANov 15, 1967 · N5427W · Substantial damage NTSB MKC68D0344Accident · No injuriesClosedPiper PA-22 · Maquoketa, IANov 12, 1967 · N6749B · Substantial damage NTSB MKC68D0343Accident · No injuriesClosedErco 415-D · Oelwein, IANov 11, 1967 · N94642 · Substantial damage NTSB MKC68D0312Accident · No injuriesClosedMooney 20F · Lamoni, IANov 11, 1967 · N9573M · Substantial damage NTSB MKC68D0277Accident · No injuriesClosedCessna 150 · Hamburg, IANov 6, 1967 · N3128J · Substantial damage NTSB MKC68D0302Accident · No injuriesClosedPiper PA-28 · Creston, IANov 5, 1967 · N5256W · Substantial damage NTSB MKC68F0281Accident · No injuriesClosedMooney M20A · Indianola, IANov 3, 1967 · N6556B · Substantial damage NTSB MKC68A0032Accident · 1 fatalClosedErco 415-C · Toledo, IAOct 27, 1967 · N93588 · Destroyed NTSB MKC68D0327Accident · No injuriesClosedCessna 182 · Lamoni, IAOct 21, 1967 · N3205U · Substantial damage