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 MKC68D0487Accident · No injuriesClosedAlon A-2 · Fort Scott, KSMar 2, 1968 · N5665F · Substantial damage NTSB MKC68D0507Accident · No injuriesClosedPiper PA-28 · Olathe, KSFeb 29, 1968 · N4536R · Substantial damage NTSB MKC68D0476Accident · No injuriesClosedCessna 150 · Russell, KSFeb 28, 1968 · N4797X · Substantial damage NTSB MKC68D0475Accident · Minor injuriesClosedPiper J3 · Kingman, KSFeb 25, 1968 · N92067 · Substantial damage NTSB MKC68D0453Accident · No injuriesClosedBeech A23 · Valley Centr, KSFeb 12, 1968 · N7949L · Substantial damage NTSB MKC68F0454Accident · Minor injuriesClosedBeech K35 · Oakley, KSFeb 11, 1968 · N5334E · Substantial damage NTSB MKC68D0422Accident · No injuriesClosedCessna 177 · Norton, KSFeb 3, 1968 · N2367Y · Substantial damage NTSB MKC68F0449Accident · Minor injuriesClosedCessna 150 · Kansas City, KSFeb 2, 1968 · N6738F · Substantial damage NTSB MKC68F0445Accident · Serious injuriesClosedPiper PA-15 · Ottawa, KSFeb 2, 1968 · N4151H · Destroyed NTSB MKC68F0414Accident · No injuriesClosedMooney M20E · Wichita, KSJan 28, 1968 · N2716W · Substantial damage NTSB MKC68D0440Accident · No injuriesClosedAeronca 11AC · Moundridge, KSJan 26, 1968 · N3387E · Substantial damage NTSB MKC68F0450Accident · No injuriesClosedCessna 182J · Kansas City, KSJan 24, 1968 · N2905F · Substantial damage NTSB MKC68D0413Accident · No injuriesClosedCessna 150 · Smith Center, KSJan 24, 1968 · N6658F · Substantial damage NTSB MKC68D0411Accident · No injuriesClosedCessna 177 · Hays, KSJan 19, 1968 · N2319Y · Substantial damage NTSB MKC68D0501Accident · No injuriesClosedPiper PA-28 · Kansas City, KSJan 7, 1968 · N6891W · Substantial damage NTSB MKC68F0400Accident · No injuriesClosedBeech V35 · Holcomb, KSJan 5, 1968 · N2777T · Substantial damage NTSB MKC68A0040Accident · 1 fatalClosedLuscombe 8A · Lyons, KSDec 24, 1967 · N71543 · Destroyed NTSB MKC68A0039Accident · 1 fatalClosedCessna 150D · Hillsboro, KSDec 24, 1967 · N4227U · Destroyed NTSB MKC68D0389Accident · No injuriesClosedCessna 172 · Ames, KSDec 20, 1967 · N7048T · Substantial damage NTSB MKC68D0374Accident · No injuriesClosedCessna 150F · Severy, KSDec 20, 1967 · N6778F · Substantial damage NTSB MKC68D0370Accident · No injuriesClosedCessna 172G · St.Francis, KSDec 7, 1967 · N3735L · Substantial damage NTSB MKC68D0368Accident · No injuriesClosedLuscombe 8A · Fostoria, KSDec 1, 1967 · N71382 · Substantial damage NTSB MKC68A0035Accident · No injuriesClosedPiper PA-24 · Sharn Sprngs, KSNov 26, 1967 · N9184P · Substantial damage NTSB MKC68D0417Accident · No injuriesClosedPiper PA-28 · Olathe, KSNov 25, 1967 · N6452W · Substantial damage NTSB MKC68F0320Accident · Serious injuriesClosedTaylorcraft DCO-65 · Leoti, KSNov 19, 1967 · N47672 · Substantial damage NTSB MKC68F0324Accident · No injuriesClosedCessna 182K · Augusta, KSNov 18, 1967 · N3103F · Substantial damage NTSB CHI68F0424Accident · No injuriesClosedCessna 310L · Wichita, KSNov 14, 1967 · N2207F · Substantial damage NTSB MKC68D0341Accident · No injuriesClosedBeech 35 · Smith Center, KSNov 12, 1967 · N4540V · Substantial damage NTSB MKC68D0461Accident · No injuriesClosedBeech 23 · Lawrence, KSNov 11, 1967 · N2314Z · Substantial damage NTSB MKC68D0419Accident · No injuriesClosedPiper PA-28 · Ottawa, KSNov 11, 1967 · N5366W · Substantial damage NTSB MKC68F0300Accident · No injuriesClosedPiper PA-25 · Leroy, KSNov 10, 1967 · N6591Z · Substantial damage NTSB MKC68D0405Accident · No injuriesClosedCessna 150E · Leawood, KSNov 4, 1967 · N3502J · Substantial damage NTSB MKC68F0301Accident · Minor injuriesClosedCessna 310 · Concordia, KSOct 28, 1967 · N191R · Substantial damage NTSB MKC68A0033Accident · No injuriesClosedCessna 210 · Iola, KSOct 27, 1967 · N5800F · Substantial damage NTSB MKC68D0294Accident · No injuriesClosedPiper PA-22 · Tribune, KSOct 12, 1967 · N2860Z · Substantial damage NTSB MKC68D0381Accident · No injuriesClosedCessna 182 · Bonner Sprgs, KSOct 11, 1967 · N2613Q · Substantial damage NTSB MKC68F0268Accident · Minor injuriesClosedCessna 182 · Wichita, KSOct 6, 1967 · N3354F · Substantial damage NTSB MKC68D0291Accident · No injuriesClosedCessna 140 · Junction Cty, KSSep 28, 1967 · N3604V · Substantial damage NTSB MKC68D0243Accident · No injuriesClosedPiper PA-22 · Independence, KSSep 24, 1967 · N99570 · Substantial damage NTSB MKC68F0256Accident · Serious injuriesClosedPiper PA-23 · Emporia, KSSep 21, 1967 · N3321P · Substantial damage NTSB MKC68D0223Accident · Minor injuriesClosedCessna 140 · Clay Center, KSSep 13, 1967 · N89378 · Substantial damage NTSB MKC68D0387Accident · No injuriesClosedCessna 150 · Olathe, KSSep 11, 1967 · N6664F · Substantial damage NTSB MKC68D0202Accident · No injuriesClosedBeech 35 · Augusta, KSSep 11, 1967 · N3758N · Substantial damage NTSB MKC68F0248Accident · No injuriesClosedPiper PA-28 · Easton, KSSep 6, 1967 · N7182R · Substantial damage NTSB MKC68D0168Accident · No injuriesClosedCessna 150 · Emporia, KSSep 4, 1967 · N3854J · Substantial damage NTSB MKC68F0321Accident · No injuriesClosedBeech B35 · Coldwater, KSSep 3, 1967 · N5026C · Substantial damage NTSB MKC68F0190Accident · No injuriesClosedBeech 65 · Wichita, KSSep 3, 1967 · N154F · Substantial damage NTSB MKC68D0196Accident · Minor injuriesClosedPiper PA-22 · Goodland, KSSep 2, 1967 · N2705P · Substantial damage NTSB MKC68A0017Accident · 2 fatalClosedCessna 182D · Grenola, KSSep 2, 1967 · N9096X · Destroyed NTSB MKC68F0383Accident · Minor injuriesClosedErco 415C · Bonner Sprngs, KSAug 25, 1967 · N99771 · Substantial damage