Skip to content

NTSB investigations, KS

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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" = 'KS' 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\" = 'KS' 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" = 'KS' 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 MKC78FCQ29Accident · No injuriesClosedPiper PA-24 · Wichita, KSJun 22, 1978 · N6549P · Substantial damage NTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSJun 20, 1978 · N9576Q · Destroyed NTSB MKC78FA047Accident · 1 fatalClosedCessna 120 · Abilene, KSJun 11, 1978 · N1959V · Destroyed NTSB MKC78FCQ26Accident · Minor injuriesClosedBell 47J-2 · Onaga, KSJun 1, 1978 · N6224N · Substantial damage NTSB MKC78DCQ25Accident · Minor injuriesClosedCessna 188 · Deerfield, KSMay 29, 1978 · N78560 · Substantial damage NTSB MKC78DCQ24Accident · No injuriesClosedCessna P337G · Meade, KSMay 28, 1978 · N264 · Substantial damage NTSB MKC78DA040Accident · No injuriesClosedThunder AX7-77 · Lindsborg, KSMay 20, 1978 · N48189 · Substantial damage NTSB MKC78FA038Accident · 1 fatalClosedPiper PA-28 · Scott City, KSMay 19, 1978 · N9395W · Destroyed NTSB MKC78DCQ23Accident · Minor injuriesClosedBellanca 17-30A · Great Bend, KSMay 18, 1978 · N14716 · Destroyed NTSB MKC78FCG30Accident · No injuriesClosedCessna 170B · Overbrook, KSMay 15, 1978 · N4411B · Substantial damage NTSB MKC78FCQ22Accident · No injuriesClosedCessna 182 · Augusta, KSMay 3, 1978 · N1466S · Substantial damage NTSB MKC78DCQ21Accident · No injuriesClosedTaylorcraft BC12D · Hayes, KSMay 1, 1978 · N95267 · Substantial damage NTSB MKC78FA035Accident · 2 fatalClosedVultee BT-13 · Augusta, KSApr 29, 1978 · N64470 · 2 aircraft · Destroyed NTSB MKC78FCQ20Accident · Serious injuriesClosedCessna 210 · Marysville, KSApr 28, 1978 · N1679X · Substantial damage NTSB MKC78FCQ19Accident · No injuriesClosedPitts S1D · Offerle, KSApr 23, 1978 · N64585 · Substantial damage NTSB MKC78FA031Accident · 1 fatalClosedBeech A23-24 · Wichita, KSApr 16, 1978 · N7934L · Destroyed NTSB MKC78FCG23Accident · No injuriesClosedCessna T337G · Topeka, KSApr 4, 1978 · N42C · Substantial damage NTSB MKC78DCG20Accident · No injuriesClosedCessna 150M · Lawrence, KSMar 28, 1978 · N704RQ · Substantial damage NTSB MKC78FA029Accident · 2 fatalClosedCessna 172 · Leawood, KSMar 19, 1978 · N6892A · Destroyed NTSB MKC78DCQ18Accident · No injuriesClosedCessna 180 · Baxter Springs, KSMar 19, 1978 · N9661B · Substantial damage NTSB MKC78DCQ17Accident · No injuriesClosedCessna 172A · Syracuse, KSMar 13, 1978 · N7649T · Substantial damage NTSB MKC78FA025Accident · No injuriesClosedAero Comdr 500B · Hutchinson, KSMar 7, 1978 · N888CA · Substantial damage NTSB MKC78FCG16Accident · No injuriesClosedCessna 310 · Bonner Springs, KSFeb 23, 1978 · N6996T · Substantial damage NTSB MKC78DCQ16Accident · No injuriesClosedCessna 182 · Manhattan, KSFeb 18, 1978 · N1431M · Substantial damage NTSB MKC78FCQ14Accident · No injuriesClosedBeech V35 · Lucas, KSJan 26, 1978 · N7992M · Substantial damage NTSB MKC78DCQ15Accident · Minor injuriesClosedCessna R172E · Wichita, KSJan 25, 1978 · N65519 · Substantial damage NTSB MKC78FCQ13Accident · Serious injuriesClosedPiper PA-32R · Wichita, KSJan 8, 1978 · N7925C · Substantial damage NTSB MKC78FA017Accident · 2 fatalClosedCessna 310L · Garden City, KSJan 1, 1978 · N2254F · Destroyed NTSB MKC78DCQ12Accident · Minor injuriesClosedCessna 150 · Russell, KSDec 30, 1977 · N704ES · Destroyed NTSB MKC78DCQ11Accident · No injuriesClosedCessna 172 · Phillipsburg, KSDec 27, 1977 · N75556 · Substantial damage NTSB MKC78DCQ10Accident · No injuriesClosedPiper PA-28 · Leoti, KSDec 20, 1977 · N4692R · Substantial damage NTSB MKC78DCQ09Accident · No injuriesClosedCessna 172N · Wichita, KSDec 17, 1977 · N738KL · Substantial damage NTSB MKC78FCQ08Accident · Minor injuriesClosedPiper PA-18 · Cimarron, KSDec 13, 1977 · N161T · Substantial damage NTSB MKC78FCG11Accident · Minor injuriesClosedCessna 177 · Olathe, KSDec 5, 1977 · N2860X · Destroyed NTSB MKC78DCQ05Accident · Minor injuriesClosedCessna 150 · Wellington, KSNov 27, 1977 · N704VU · Substantial damage NTSB MKC78FCQ07Accident · No injuriesClosedCessna 152 · Wilmont, KSNov 19, 1977 · N25057 · Destroyed NTSB MKC78DCQ06Accident · No injuriesClosedCessna 177RG · Wichita, KSNov 11, 1977 · N1917Q · Substantial damage NTSB MKC78DCG07Accident · No injuriesClosedCessna 182 · Kansas City, KSNov 5, 1977 · N3704U · Substantial damage NTSB MKC78FA007Accident · 1 fatalClosedCessna 310 · Kansas City, KSNov 4, 1977 · N777BB · Destroyed NTSB MKC78DCQ03Accident · No injuriesClosedAero Comdr 112A · Moran, KSOct 30, 1977 · N76EE · Substantial damage NTSB MKC78FCQ02Accident · No injuriesClosedCessna 150 · Emporia, KSOct 27, 1977 · N10996 · Substantial damage NTSB MKC78FCQ04Accident · No injuriesClosedBeech A-36 · Garden City, KSOct 22, 1977 · N950V · Substantial damage NTSB MKC78FCQ01Accident · Minor injuriesClosedCessna 152 · Stafford, KSOct 8, 1977 · N757ZT · Substantial damage NTSB MKC78DCG03Accident · No injuriesClosedCessna 172 · Lawrence, KSOct 8, 1977 · N737DC · Substantial damage NTSB MKC78FA001Accident · 2 fatalClosedNavion A · Caldwell, KSOct 6, 1977 · N91482 · Destroyed NTSB MKC77DCQ61Accident · No injuriesClosedCessna 170A · Syracuse, KSSep 28, 1977 · N166LJ · Substantial damage NTSB MKC77DCQ60Accident · No injuriesClosedChampion 7ECA · Byers, KSSep 24, 1977 · N1811G · Substantial damage NTSB MKC77DCQ59Accident · No injuriesClosedCessna 172 · Kiowa, KSSep 22, 1977 · N733XB · Substantial damage NTSB MKC77FCQ58Accident · No injuriesClosedBeech C-23 · Wichita, KSSep 17, 1977 · N246CB · Substantial damage NTSB MKC77FA039Accident · 2 fatalClosedCessna 177 · Coldwater, KSSep 15, 1977 · N29358 · Destroyed