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 MKC74FCQ11Accident · No injuriesClosedBoeing A75L · Ingalls, KSAug 3, 1973 · N9383H · Substantial damage NTSB MKC74FCQ04Accident · Serious injuriesClosedFairchild M62C · Garden City, KSAug 3, 1973 · N57606 · Substantial damage NTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSAug 1, 1973 · N60051 · Substantial damage NTSB MKC74DCQ03Accident · Minor injuriesClosedPiper PA-25 · Grove, KSJul 27, 1973 · N4927Y · Substantial damage NTSB MKC74DCQ01Accident · No injuriesClosedCessna 188A · Sublette, KSJul 26, 1973 · N5685J · Substantial damage NTSB MKC73DCQ38Accident · No injuriesClosedCessna 188 · North Fowler, KSJun 27, 1973 · N9899V · Substantial damage NTSB MKC73FCQ36Accident · No injuriesClosedHughes 369HS · Wichita, KSJun 7, 1973 · CF-IAD · Substantial damage NTSB MKC73DCQ37Accident · No injuriesClosedCessna 172D · Councl Grove, KSJun 3, 1973 · N2630U · Substantial damage NTSB MKC73DCQ35Accident · No injuriesClosedAeronca 7AC · Hunter, KSJun 3, 1973 · N84055 · Substantial damage NTSB MKC73DCG48Accident · Minor injuriesClosedBoeing B75N1 · Garnett, KSMay 30, 1973 · N75567 · Substantial damage NTSB MKC73AK071Accident · 1 fatalClosedBeech 95-B55 · Wichita, KSMay 27, 1973 · N306H · Destroyed NTSB MKC73AK069Accident · 1 fatalClosedBeech B35 · Mulvane, KSMay 26, 1973 · N5164C · Destroyed NTSB MKC73FCG42Accident · No injuriesClosedTaylorcraft BL-65 · Leavenworth, KSMay 23, 1973 · N27492 · 2 aircraft · Substantial damage NTSB MKC73DCQ33Accident · No injuriesClosedPiper PA-28 · Marysville, KSMay 23, 1973 · N5579F · Substantial damage NTSB MKC73DCQ32Accident · No injuriesClosedCessna 182A · Yates Center, KSMay 22, 1973 · N4817D · Substantial damage NTSB MKC73FCQ34Accident · No injuriesClosedCessna 182L · Scandia, KSMay 20, 1973 · N3182R · Substantial damage NTSB MKC73FCG41Accident · Serious injuriesClosedPiper PA-28 · Burlington, KSMay 20, 1973 · N95152 · Destroyed NTSB MKC73AK067Accident · No injuriesClosedCessna 182P · Yates Center, KSMay 18, 1973 · N7074Q · Destroyed NTSB MKC73DCQ31Accident · No injuriesClosedGrumman G-164A · Mccune, KSMay 16, 1973 · N4698 · Substantial damage NTSB MKC73FCQ30Accident · Serious injuriesClosedPiper PA-25 · Meade, KSMay 12, 1973 · N7277Z · Destroyed NTSB MKC73AK066Accident · 4 fatalClosedBeech E90 · Pratt, KSMay 10, 1973 · YV-TADJ · Destroyed NTSB MKC73DCQ29Accident · Minor injuriesClosedBoeing A75N1 · Pittsburg, KSMay 4, 1973 · N54782 · Substantial damage NTSB MKC73DCQ28Accident · Minor injuriesClosedCessna 188 · Mccune, KSMay 2, 1973 · N1556M · Destroyed NTSB MKC73DCG38Accident · No injuriesClosedCessna 172 · Leavenworth, KSApr 19, 1973 · N7733T · Substantial damage NTSB MKC73AK063Accident · No injuriesClosedBeech 99A · Wichita, KSApr 18, 1973 · N3990A · Substantial damage NTSB MKC73AK061Accident · 1 fatalClosedBeech E35 · Junction Cty, KSApr 14, 1973 · N7339B · Destroyed NTSB MKC73FCG37Accident · No injuriesClosedBeech 35-A33 · Leawood, KSApr 9, 1973 · N537T · Substantial damage NTSB MKC73DCQ27Accident · No injuriesClosedPiper PA-30 · Meade, KSMar 29, 1973 · CF-PKC · Substantial damage NTSB MKC73DCQ25Accident · No injuriesClosedPiper PA-24 · Harper, KSMar 26, 1973 · N7918P · Substantial damage NTSB MKC73FCG35Accident · Minor injuriesClosedCessna 150G · Leawood, KSMar 25, 1973 · N3157J · Substantial damage NTSB MKC73DCQ26Accident · No injuriesClosedGrumman G-164 · Attica, KSMar 21, 1973 · N646Y · Substantial damage NTSB MKC73AK056Accident · Minor injuriesClosedBoeing 727 · Wichita, KSMar 3, 1973 · N12307 · Substantial damage NTSB MKC73AK054Accident · Serious injuriesClosedCessna 210F · Manhattan, KSFeb 25, 1973 · N5800F · Destroyed NTSB MKC73FCG29Accident · No injuriesClosedPiper PA-28R · Atchison, KSFeb 19, 1973 · N15021 · Substantial damage NTSB MKC73AK050Accident · 1 fatalClosedPiper PA-22 · Washington, KSJan 23, 1973 · N3652A · Destroyed NTSB MKC73AK047Accident · 1 fatalClosedCessna 172K · Wichita, KSJan 18, 1973 · N7047G · Destroyed NTSB MKC73DCG25Accident · No injuriesClosedPiper PA-28 · Olathe, KSJan 5, 1973 · N9878W · Substantial damage NTSB MKC73DCQ24Accident · No injuriesClosedCessna 210 · Manhattan, KSDec 29, 1972 · N19BB · Substantial damage NTSB MKC73FCQ23Accident · 1 fatalClosedBeard-Parkr Mini · Benton, KSDec 26, 1972 · N6699 · Substantial damage NTSB MKC73AK046Accident · 2 fatalClosedPiper PA-32 · Great Bend, KSDec 23, 1972 · N5263S · Destroyed NTSB MKC73AK044Accident · 4 fatalClosedCessna 320E · Goodland, KSDec 22, 1972 · N2208Q · Destroyed NTSB MKC73AK042Accident · 2 fatalClosedCessna 172 · Concordia, KSDec 19, 1972 · N46155 · Destroyed NTSB MKC73FCQ22Accident · No injuriesClosedCessna 402B · Wichita, KSDec 3, 1972 · N13GM · Substantial damage NTSB MKC73FCG23Accident · No injuriesClosedCessna 177 · Olathe, KSNov 18, 1972 · N3452T · Substantial damage NTSB MKC73DCG20Accident · No injuriesClosedPiper PA-28 · Louisburg, KSNov 12, 1972 · N9354N · Substantial damage NTSB MKC73AK035Accident · 2 fatalClosedCessna 320F · Ashland, KSNov 4, 1972 · N9900X · Destroyed NTSB MKC73DCQ21Accident · Minor injuriesClosedCessna 150J · Derby, KSOct 29, 1972 · N61140 · Substantial damage NTSB MKC73DCQ20Accident · No injuriesClosedCessna 182 · Benton, KSOct 19, 1972 · N91703 · Substantial damage NTSB MKC73DCQ19Accident · No injuriesClosedPiper PA-32 · Pittsburg, KSOct 18, 1972 · N4005R · Substantial damage NTSB MKC73FCQ17Accident · No injuriesClosedBede BD5A · Newton, KSOct 8, 1972 · N501BD · Substantial damage