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 MKC67D0598Accident · No injuriesClosedCessna 421 · Wichita, KSMay 25, 1967 · N3758C · Substantial damage NTSB MKC67A0072Accident · No injuriesClosedCessna U206 · Winfield, KSMay 22, 1967 · N5180U · Substantial damage NTSB MKC67A0069Accident · 2 fatalClosedPiper L-21A · Lowemont, KSMay 20, 1967 · N61294 · Destroyed NTSB MKC68D0070Accident · No injuriesClosedCessna 172 · Kinsley, KSMay 18, 1967 · N5639A · Substantial damage NTSB MKC68D0032Accident · No injuriesClosedCessna 172H · Dighton, KSMay 18, 1967 · N7129T · Substantial damage NTSB MKC67D0587Accident · No injuriesClosedPiper PA-28 · Plainville, KSMay 18, 1967 · N7591W · Substantial damage NTSB MKC67D0596Accident · No injuriesClosedAlon A-2 · Wichita, KSMay 17, 1967 · N5611F · Substantial damage NTSB MKC67D0588Accident · No injuriesClosedMooney M20E · Garden City, KSMay 17, 1967 · N79858 · Substantial damage NTSB MKC67F0575Accident · No injuriesClosedMooney M20E · Dighton, KSMay 15, 1967 · N9310M · Substantial damage NTSB MKC68D0141Accident · No injuriesClosedCessna 180 · Lawrence, KSMay 11, 1967 · N3899C · Substantial damage NTSB MKC67D0597Accident · No injuriesClosedPiper PA-23 · Emporia, KSMay 7, 1967 · N4960P · Substantial damage NTSB MKC67F0564Accident · No injuriesClosedPiper PA-28 · Newton, KSMay 1, 1967 · N4515R · Substantial damage NTSB MKC67F0605Accident · Minor injuriesClosedCessna 172 · Topeka, KSApr 30, 1967 · N2457L · Substantial damage NTSB MKC67D0579Accident · No injuriesClosedAeronca 7AC · Dodge City, KSApr 29, 1967 · N84506 · Substantial damage NTSB MKC67D0589Accident · No injuriesClosedCessna 182 · Syracuse, KSApr 28, 1967 · N9216X · Substantial damage NTSB MKC67F0580Accident · Minor injuriesClosedCessna 140 · Lakin, KSApr 27, 1967 · N2326V · Substantial damage NTSB MKC67D0551Accident · No injuriesClosedBeech A23 · Liberal, KSApr 26, 1967 · N2353W · Substantial damage NTSB MKC67F0552Accident · No injuriesClosedCessna 150 · Fall River, KSApr 22, 1967 · N5792E · Substantial damage NTSB MKC67D0594Accident · No injuriesClosedCessna 150 · Lawrence, KSApr 22, 1967 · N8778G · Substantial damage NTSB MKC67D0572Accident · No injuriesClosedPiper PA-28 · Hugoton, KSApr 19, 1967 · N8405W · Substantial damage NTSB MKC67D0586Accident · No injuriesClosedCessna 150 · Hays, KSApr 18, 1967 · N8501J · Substantial damage NTSB MKC67F0544Accident · No injuriesClosedPiper PA-24 · Kansas City, KSApr 14, 1967 · N6439P · Substantial damage NTSB MKC67F0530Accident · Minor injuriesClosedPiper PA-22 · Valley Ctr, KSApr 2, 1967 · N833A · Substantial damage NTSB MKC67F0532Accident · No injuriesClosedPiper PA-24 · Kansas Cty, KSMar 31, 1967 · N8651P · Substantial damage NTSB MKC67D0538Accident · No injuriesClosedCessna 206 · Kansas City, KSMar 30, 1967 · N4980F · Substantial damage NTSB MKC67D0469Accident · No injuriesClosedCessna 182K · Russell, KSMar 29, 1967 · N2623Q · Substantial damage NTSB MKC67D0497Accident · Minor injuriesClosedCessna 172 · Wichita, KSMar 24, 1967 · N2825L · Substantial damage NTSB MKC67D0489Accident · No injuriesClosedMooney M20C · Wichita, KSMar 19, 1967 · N6518U · Substantial damage NTSB MKC67D0488Accident · No injuriesClosedCessna 120 · Clayton, KSMar 19, 1967 · N1731N · Substantial damage NTSB MKC67F0475Accident · No injuriesClosedCessna 150 · Eudora, KSMar 12, 1967 · N6224T · Substantial damage NTSB MKC67D0496Accident · No injuriesClosedCessna 150 · Brookville, KSMar 12, 1967 · N2465J · Substantial damage NTSB MKC67D0517Accident · No injuriesClosedBellanca 14-19 · Liberal, KSMar 10, 1967 · N7672B · Substantial damage NTSB MKC67D0446Accident · No injuriesClosedCessna 150 · Wichita, KSMar 9, 1967 · N7777E · Substantial damage NTSB MKC67D0495Accident · No injuriesClosedCessna 182A · Kinsley, KSMar 6, 1967 · N6127B · Substantial damage NTSB MKC67D0474Accident · No injuriesClosedCessna 172 · Severance, KSMar 4, 1967 · N1343Y · Substantial damage NTSB MKC67D0566Accident · No injuriesClosedMooney M20C · Lawrence, KSFeb 28, 1967 · N6008Q · Substantial damage NTSB MKC67D0485Accident · Minor injuriesClosedCessna 172H · Cassody, KSFeb 26, 1967 · N3914R · Substantial damage NTSB MKC67D0445Accident · No injuriesClosedCessna 182K · Wichita, KSFeb 23, 1967 · NPT-CXA · Substantial damage NTSB MKC67D0437Accident · No injuriesClosedCessna 337 · Wichita, KSFeb 20, 1967 · N6309F · Substantial damage NTSB MKC67F0448Accident · No injuriesClosedCessna 182 · Norton, KSFeb 18, 1967 · N3352F · Substantial damage NTSB MKC67D0450Accident · No injuriesClosedPiper PA-24 · Olathe, KSFeb 18, 1967 · N8437P · Substantial damage NTSB MKC67D0431Accident · No injuriesClosedCessna 172 · Onaga, KSFeb 11, 1967 · N8331B · Substantial damage NTSB MKC67F0419Accident · No injuriesClosedCessna 140A · Kansas City, KSFeb 8, 1967 · N9606A · Substantial damage NTSB MKC67D0449Accident · No injuriesClosedBeech 35C33A · Mcpherson, KSFeb 6, 1967 · N9524Q · Substantial damage NTSB MKC67F0418Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 29, 1967 · N8550G · Substantial damage NTSB MKC67F0425Accident · Minor injuriesClosedCessna 172H · Wichita, KSJan 25, 1967 · N2526L · Substantial damage NTSB MKC67F0433Accident · No injuriesClosedCessna 206 · Winfield, KSJan 18, 1967 · N5180U · Substantial damage NTSB MKC67F0398Accident · No injuriesClosedCessna 337 · El Dorado, KSJan 18, 1967 · N6319F · Substantial damage NTSB MKC67F0447Accident · No injuriesClosedBeech C50 · Goodland, KSJan 16, 1967 · N663FT · Substantial damage NTSB MKC67A0043Accident · 2 fatalClosedChampion 7ECA · Stillwell, KSJan 13, 1967 · N8394V · Destroyed