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 MKC75DCQ55Accident · No injuriesClosedBellanca 7GCBC · Minneola, KSJun 17, 1975 · N87069 · Substantial damage NTSB MKC75DCQ54Accident · Minor injuriesClosedMiller Teenie · Pratt, KSJun 15, 1975 · N4608 · Substantial damage NTSB NYC75DCQ53Accident · No injuriesClosedAmer Avco AA1-B · Manhattan, KSJun 13, 1975 · N8889L · Substantial damage NTSB MKC75FCQ52Accident · No injuriesClosedBell 47D1 · Holcomb, KSJun 12, 1975 · N7735 · Substantial damage NTSB MKC75FCQ51Accident · 1 fatalClosedChampion 7GCBC · Hill City, KSJun 6, 1975 · N269S · Destroyed NTSB MKC75DCQ50Accident · No injuriesClosedCessna 172U · Goodland, KSJun 2, 1975 · N7869G · Substantial damage NTSB MKC75FCG49Accident · Serious injuriesClosedHughes 269A · Rossville, KSJun 1, 1975 · N8898F · Destroyed NTSB MKC75DCQ49Accident · No injuriesClosedCessna 210 · Gove, KSMay 26, 1975 · N9513X · Substantial damage NTSB MKC75FCG47Accident · Minor injuriesClosedCessna 150 · Kansas City, KSMay 24, 1975 · N18600 · Destroyed NTSB MKC75AK054Accident · 3 fatalClosedPiper PA-28 · Sawyer, KSMay 22, 1975 · N8359R · Destroyed NTSB MKC75DCG45Accident · Minor injuriesClosedCessna 150 · Meriden, KSMay 18, 1975 · N6644S · Substantial damage NTSB MKC75DCQ48Accident · No injuriesClosedCessna 188 · Selden, KSMay 13, 1975 · N5642J · Substantial damage NTSB MKC75DCG43Accident · No injuriesClosedPiper PA-28 · Olathe, KSMay 8, 1975 · N9736W · Substantial damage NTSB MKC75DCQ46Accident · No injuriesClosedCessna 172 · Wamego, KSMay 7, 1975 · N9876V · Substantial damage NTSB MKC75DC045Accident · Minor injuriesClosedPiper PA-25 · Chanute, KSMay 7, 1975 · N8815L · Substantial damage NTSB MKC75FCQ43Accident · Serious injuriesClosedBeech 95-B55 · Beaumont, KSMay 4, 1975 · N8975M · Substantial damage NTSB MKC75FCQ44Accident · Serious injuriesClosedPiper PA-28 · Medicine Lodge, KSMay 3, 1975 · N1519J · Substantial damage NTSB MKC75DCQ47Accident · No injuriesClosedCessna A188B · Stafford, KSApr 28, 1975 · N53187 · Substantial damage NTSB MKC75DCQ42Accident · No injuriesClosedCessna 182 · Elkhart, KSApr 15, 1975 · N8653T · Substantial damage NTSB MKC75DCQ40Accident · No injuriesClosedPiper PA-22 · Leoti, KSApr 7, 1975 · N2952Z · Destroyed NTSB MKC75DCQ41Accident · No injuriesClosedPiper PA-24 · Emporia, KSApr 5, 1975 · N5915P · Substantial damage NTSB MKC75DCQ39Accident · Minor injuriesClosedCessna 150 · Colby, KSApr 5, 1975 · N10916 · Destroyed NTSB MKC75AK050Accident · 2 fatalClosedBeech A36 · Wichita, KSMar 24, 1975 · N36SL · Destroyed NTSB MKC75FCQ38Accident · No injuriesClosedCessna 150 · Pratt, KSMar 20, 1975 · N11139 · Substantial damage NTSB MKC75FCG33Accident · No injuriesClosedCessna 150 · Topeka, KSMar 15, 1975 · N22801 · Substantial damage NTSB MKC75FCQ37Accident · Minor injuriesClosedHughes 269A · Hutchinson, KSMar 12, 1975 · N8927F · Substantial damage NTSB MKC75DCQ36Accident · No injuriesClosedCessna 172 · Wichita, KSMar 5, 1975 · N5098R · Substantial damage NTSB MKC75AK046Accident · 1 fatalClosedBeech D18S · Dodge City, KSMar 3, 1975 · N311D · Destroyed NTSB MKC75DCQ34Accident · No injuriesClosedErco 415-C · Dodge City, KSFeb 28, 1975 · N87078 · Substantial damage NTSB MKC75DCQ35Accident · No injuriesClosedBeech C23 · Wichita, KSFeb 20, 1975 · N6566R · Substantial damage NTSB MKC75DCQ33Accident · No injuriesClosedCessna 150 · Concordia, KSFeb 19, 1975 · N1366Q · Substantial damage NTSB MKC75FCQ32Accident · No injuriesClosedCessna 402B · Wichita, KSFeb 18, 1975 · N69375 · Substantial damage NTSB MKC75AK042Accident · No injuriesClosedAero Comdr 560 · Leawood, KSFeb 12, 1975 · N2730B · Substantial damage NTSB MKC75AK040Accident · 1 fatalClosedCessna 210B · Wichita, KSFeb 11, 1975 · N9728X · Destroyed NTSB MKC75AK038Accident · 1 fatalClosedAero Comdr 680V · Olathe, KSJan 31, 1975 · N399T · Destroyed NTSB MKC75AK037Accident · Serious injuriesClosedCessna 402B · Dodge City, KSJan 31, 1975 · N1415G · Destroyed NTSB MKC75DCQ30Accident · No injuriesClosedCessna 172 · Norton, KSJan 25, 1975 · N13517 · Substantial damage NTSB MKC75DCQ27Accident · No injuriesClosedBeech C23 · Stafford, KSJan 4, 1975 · N2121W · Substantial damage NTSB MKC75DCQ31Accident · No injuriesClosedBeech J35 · Scott City, KSDec 29, 1974 · N7269B · Substantial damage NTSB MKC75FCG24Accident · Minor injuriesClosedBeech P35 · Leawood, KSDec 23, 1974 · N1582S · Substantial damage NTSB MKC75DCQ26Accident · No injuriesClosedCessna 172 · Conway, KSDec 12, 1974 · N8857B · Substantial damage NTSB MKC75ACQ28Accident · No injuriesClosedBeech 95-B55 · Phillipsburg, KSDec 11, 1974 · N5603K · Substantial damage NTSB MKC75DCQ25Accident · No injuriesClosedPiper PA-28 · St Francis, KSNov 27, 1974 · N6367J · Substantial damage NTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNov 24, 1974 · N6420F · Substantial damage NTSB MKC75FCQ24Accident · Minor injuriesClosedHughes 269C · Greenwich, KSNov 20, 1974 · N8968F · Substantial damage NTSB MKC75DCQ23Accident · No injuriesClosedAmer Avco AA1-B · Norton, KSNov 14, 1974 · N9971L · Substantial damage NTSB MKC75AK026Accident · 1 fatalClosedHughes 269C · Topeka, KSNov 1, 1974 · N9648F · Destroyed NTSB MKC75AK025Accident · 1 fatalClosedCessna 172 · Abilene, KSOct 25, 1974 · N7300T · Destroyed NTSB MKC75FCQ21Accident · Serious injuriesClosedBeech A24R · Caney, KSOct 9, 1974 · N9768L · Destroyed NTSB MKC75FCQ20Accident · Minor injuriesClosedGrumman G-21 · Wichita, KSOct 9, 1974 · N75333 · Substantial damage