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 MKC66F0543Accident · Serious injuriesClosedCallair A-7 · Wichita, KSApr 16, 1966 · N2919G · Substantial damage NTSB MKC66F0569Accident · No injuriesClosedPiper PA-24 · Emporia, KSApr 13, 1966 · N8031P · Substantial damage NTSB MKC66D0572Accident · No injuriesClosedCessna 150 · Bonner Sprng, KSApr 8, 1966 · N4008U · Substantial damage NTSB MKC67D0012Accident · No injuriesClosedMooney M20C · Russell, KSApr 3, 1966 · N6579U · Substantial damage NTSB MKC66D0523Accident · No injuriesClosedCessna 172 · Wichita, KSApr 2, 1966 · N4225L · Destroyed NTSB MKC67D0078Accident · No injuriesClosedBeech 35 · Anthony, KSMar 16, 1966 · N3178V · Substantial damage NTSB MKC66F0473Accident · Minor injuriesClosedCessna 140 · Miltonvale, KSMar 11, 1966 · N4125N · Substantial damage NTSB MKC66D0542Accident · No injuriesClosedCessna 182 · Wichita, KSMar 5, 1966 · N6457A · Substantial damage NTSB MKC66D0479Accident · No injuriesClosedCessna 205 · Olathe, KSMar 4, 1966 · N1899Z · Substantial damage NTSB MKC66D0513Accident · No injuriesClosedCessna 172 · Wichita, KSMar 1, 1966 · N9869T · Substantial damage NTSB MKC66F0452Accident · No injuriesClosedCessna 150 · Newton, KSFeb 28, 1966 · N3554J · Substantial damage NTSB MKC66D0491Accident · Minor injuriesClosedCessna 140 · Coffeyvill, KSFeb 28, 1966 · N76152 · Destroyed NTSB MKC66A0045Accident · 2 fatalClosedCessna 150B · Emporia, KSFeb 27, 1966 · N1253Y · Destroyed NTSB MKC66D0450Accident · No injuriesClosedPiper PA-28 · Opeka, KSFeb 26, 1966 · N7539W · Substantial damage NTSB MKC66D0496Accident · Minor injuriesClosedPiper PA-22 · Wellington, KSFeb 20, 1966 · N4942Z · Substantial damage NTSB MKC66F0461Accident · No injuriesClosedMooney M20B · Hill City, KSFeb 19, 1966 · N74522 · Substantial damage NTSB MKC66D0456Accident · No injuriesClosedBeech 35-B33 · Sedan, KSFeb 19, 1966 · N1434G · Substantial damage NTSB MKC66D0423Accident · No injuriesClosedCessna 170B · Bonner Sprng, KSFeb 19, 1966 · N2778C · Substantial damage NTSB MKC66F0453Accident · No injuriesClosedCessna 175 · Manhattan, KSFeb 18, 1966 · N7056M · Destroyed NTSB MKC66F0421Accident · Minor injuriesClosedPiper J-3 · Angola, KSFeb 13, 1966 · N35311 · Substantial damage NTSB MKC66D0438Accident · No injuriesClosedCessna 182 · Bonner Sprng, KSFeb 12, 1966 · N9004X · Substantial damage NTSB MKC66F0448Accident · No injuriesClosedPiper PA-22 · Gardner, KSFeb 10, 1966 · N7155B · Substantial damage NTSB MKC66F0409Accident · No injuriesClosedCessna 150 · Emporia, KSFeb 2, 1966 · N8778G · Substantial damage NTSB MKC66D0406Accident · No injuriesClosedBeech P35 · Bentley, KSFeb 2, 1966 · N6000E · Substantial damage NTSB MKC66D0384Accident · No injuriesClosedChampion 7ECA · Olathe, KSFeb 2, 1966 · N9510S · Substantial damage NTSB MKC66D0498Accident · No injuriesClosedPiper PA-28 · Sublette, KSJan 29, 1966 · N8169W · Substantial damage NTSB MKC66D0481Accident · No injuriesClosedCessna 180 · Goodland, KSJan 29, 1966 · N9580B · Substantial damage NTSB MKC66F0396Accident · Serious injuriesClosedPiper PA-22 · Herington, KSJan 17, 1966 · N1165C · Destroyed NTSB MKC66D0393Accident · No injuriesClosedPiper PA-28 · Mcpherson, KSJan 17, 1966 · N6485W · Substantial damage NTSB MKC66A0039Accident · No injuriesClosedHughes 269A · Rantoul, KSJan 16, 1966 · N8904F · Substantial damage NTSB MKC66F0395Accident · No injuriesClosedBeech 35 · Salinga, KSJan 14, 1966 · N5783N · Substantial damage NTSB MKC66F0367AccidentClosedStinson L-5 · Desoto, KSJan 13, 1966 · N7605B · Substantial damage NTSB MKC66F0369Accident · No injuriesClosedMooney M20C · Kansas City, KSJan 5, 1966 · N6560U · Substantial damage NTSB MKC66A0036Accident · 2 fatalClosedCessna T-210F · Mayfield, KSJan 4, 1966 · N6708R · Destroyed NTSB MKC66D0394Accident · No injuriesClosedCessna 337 · Arkansas City, KSJan 3, 1966 · N6258F · Substantial damage NTSB MKC66F0377Accident · No injuriesClosedMooney M20A · Goodland, KSJan 2, 1966 · N8139E · Substantial damage NTSB MKC66F0336Accident · Minor injuriesClosedCessna U206 · Augusta, KSDec 31, 1965 · N8059Z · Substantial damage NTSB MKC66D0371Accident · No injuriesClosedMooney M20A · Kansas City, KSDec 31, 1965 · N6562B · Substantial damage NTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KSDec 31, 1965 · N2621F · Substantial damage NTSB MKC66D0334Accident · Minor injuriesClosedCessna 172 · Wichita, KSDec 19, 1965 · N7648X · Destroyed NTSB MKC66D0436Accident · No injuriesClosedCessna 170 · Russell, KSDec 9, 1965 · N8001A · Substantial damage NTSB MKC66D0348Accident · No injuriesClosedAeronca 7AC · Lincoln, KSDec 8, 1965 · N83703 · No damage NTSB UNK66X0113Accident · No injuriesClosedErcoupe 415-C · Stafford, KSDec 5, 1965 · N99578 · Substantial damage NTSB MKC66A0033Accident · 1 fatalClosedAeronca 11AC · Iola, KSDec 5, 1965 · N9749E · Destroyed NTSB MKC66F0309Accident · No injuriesClosedBeechcraft J35 · Salina, KSNov 14, 1965 · N8797D · Substantial damage NTSB MKC66F0318Accident · Minor injuriesClosedPiper PA-22 · Salina, KSNov 12, 1965 · N1669A · Substantial damage NTSB MKC66F0304Accident · No injuriesClosedLuscombe 8C · Wellington, KSNov 8, 1965 · N28617 · Substantial damage NTSB MKC66F0350Accident · Serious injuriesClosedForney F-1 · Burrton, KSNov 5, 1965 · N3011G · Destroyed NTSB MKC66F0319Accident · Serious injuriesClosedGlobe GC-1B · Salina, KSOct 29, 1965 · N93072 · Substantial damage NTSB MKC66F0302Accident · No injuriesClosedCessna 210 · Oakley, KSOct 26, 1965 · N9643T · Substantial damage