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 MKC74DCQ36Accident · Serious injuriesClosedPiper PA-18 · Park, KSMay 3, 1974 · N14303 · Destroyed NTSB MKC74FCQ35Accident · No injuriesClosedCessna 177 · Beaumont, KSApr 21, 1974 · N3253T · Substantial damage NTSB MKC74FCG30Accident · No injuriesClosedCessna 150 · Kansas City, KSApr 21, 1974 · N1938D · Substantial damage NTSB MKC74AK062Accident · 4 fatalClosedBeech 35 · White City, KSApr 20, 1974 · N2933V · Destroyed NTSB MKC74FCG28Accident · No injuriesClosedCessna 170A · Bonner Sprgs, KSMar 30, 1974 · N1242D · Substantial damage NTSB MKC74DCQ33Accident · No injuriesClosedLuscombe 8A · St George, KSMar 30, 1974 · N1136B · Substantial damage NTSB MKC74AK055Accident · 2 fatalClosedAeronca 7AC · Colony, KSMar 28, 1974 · N1864E · Destroyed NTSB MKC74DCQ31Accident · Serious injuriesClosedStokes AIR · El Dorado, KSMar 17, 1974 · N94465 · Substantial damage NTSB MKC74FCG24Accident · Serious injuriesClosedPiper PA-28 · Edgerton, KSMar 13, 1974 · N5630U · Destroyed NTSB MKC74DCQ30Accident · Minor injuriesClosedPiper PA-25 · Oxford, KSMar 5, 1974 · N7476Z · Substantial damage NTSB MKC74DCQ29Accident · No injuriesClosedCessna 337D · Belleville, KSMar 5, 1974 · N86397 · Substantial damage NTSB MKC74DCQ28Accident · No injuriesClosedCessna 170 · Chanute, KSMar 3, 1974 · N8027A · Substantial damage NTSB MKC74AK053Accident · Serious injuriesClosedBeech G18S · Fort Scott, KSMar 1, 1974 · N123A · Destroyed NTSB MKC74DCQ27Accident · No injuriesClosedCessna 175 · Hillsboro, KSFeb 26, 1974 · N7470M · Substantial damage NTSB MKC74DCQ26Accident · No injuriesClosedHughes 269C · Wichita, KSFeb 19, 1974 · N8968F · Substantial damage NTSB MKC74DCQ25Accident · No injuriesClosedHughes 269A · Scott City, KSFeb 5, 1974 · N8719F · Substantial damage NTSB MKC74DCG21Accident · No injuriesClosedAerostar 601 · Lawrence, KSFeb 5, 1974 · N601DP · Substantial damage NTSB MKC74AK045Accident · 1 fatalClosedPiper PA-24 · Lawrence, KSFeb 2, 1974 · N5323P · Destroyed NTSB MKC74DCQ23Accident · No injuriesClosedPiper PA-22 · Minneapolis, KSJan 26, 1974 · N8265C · Substantial damage NTSB MKC74AK040Accident · 2 fatalClosedCessna 150J · Pittsburg, KSJan 25, 1974 · N60544 · Destroyed NTSB MKC74DCG19Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 16, 1974 · N6095J · Substantial damage NTSB MKC74FCQ22Accident · No injuriesClosedPiper PA-31P · Wichita, KSJan 12, 1974 · N33CG · Substantial damage NTSB MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damage NTSB MKC74DCQ21Accident · No injuriesClosedCessna 177 · Great Bend, KSDec 22, 1973 · N30335 · Substantial damage NTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damage NTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSDec 18, 1973 · N3269X · Destroyed NTSB MKC74FCQ20Accident · Serious injuriesClosedCessna 182 · Manhattan, KSDec 3, 1973 · N21357 · Substantial damage NTSB MKC74DCQ19Accident · No injuriesClosedCessna 190 · Bennington, KSDec 1, 1973 · N1502D · Substantial damage NTSB MKC74FCG14Accident · Minor injuriesClosedLuscombe T8-F · Lenexa, KSNov 22, 1973 · N1824B · Substantial damage NTSB MKC74FER23Accident · Serious injuriesClosedBeech V35B · St Paul, KSNov 21, 1973 · N1877W · Substantial damage NTSB MKC74FCQ17Accident · No injuriesClosedPiper PA-24 · Larned, KSNov 19, 1973 · N8131P · Substantial damage NTSB MKC74AK024Accident · No injuriesClosedPiper PA-32 · Topeka, KSNov 16, 1973 · N3412W · Substantial damage NTSB MKC74FCQ18Accident · No injuriesClosedPiper PA-23 · Colby, KSNov 12, 1973 · N3237P · Substantial damage NTSB MKC74DCQ16Accident · No injuriesClosedPiper PA-23 · Salina, KSNov 2, 1973 · N6503Y · Minor damage NTSB MKC74AK019Accident · 1 fatalClosedBoeing B75N1 · Spring Hill, KSOct 21, 1973 · N121M · Destroyed NTSB MKC74FCG13Accident · No injuriesClosedBeech TC-45J · Lawrence, KSOct 17, 1973 · N200KU · Substantial damage NTSB MKC74DCQ15Accident · No injuriesClosedBoeing A75 · Plains, KSOct 13, 1973 · N75847 · Substantial damage NTSB MKC74AK017Accident · 1 fatalClosedMooney M20E · Cassoday, KSOct 9, 1973 · N6985U · Destroyed NTSB MKC74DCQ14Accident · No injuriesClosedCessna 172 · Inman, KSSep 10, 1973 · N3734F · Substantial damage NTSB MKC74AK010Accident · 4 fatalClosedCessna 182B · Leawood, KSSep 7, 1973 · N2430G · Destroyed NTSB MKC74DCQ13Accident · No injuriesClosedSmith Trmite · Goodland, KSSep 6, 1973 · N59322 · Substantial damage NTSB MKC74DCQ12Accident · No injuriesClosedPiper PA-25 · Almena, KSSep 5, 1973 · N4976Y · Substantial damage NTSB MKC74AK009Accident · 1 fatalClosedLuscombe 8E · Harper, KSSep 3, 1973 · N1655K · Destroyed NTSB MKC74AK008Accident · 1 fatalClosedCessna 150J · Emporia, KSAug 28, 1973 · N60410 · Substantial damage NTSB MKC74DCQ10Accident · No injuriesClosedPiper PA-28 · Hays, KSAug 27, 1973 · N5722U · Substantial damage NTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSAug 26, 1973 · N4190N · Substantial damage NTSB MKC74DCQ08Accident · No injuriesClosedMooney M20E · Hugoton, KSAug 23, 1973 · N5743Q · Substantial damage NTSB MKC74FCQ07Accident · Serious injuriesClosedBeech B19 · Wichita, KSAug 14, 1973 · N1923W · Substantial damage NTSB MKC74DCQ06Accident · No injuriesClosedCessna 188 · Lakin, KSAug 4, 1973 · N711RM · Substantial damage NTSB MKC74DCQ05Accident · No injuriesClosedCessna 210J · Johnson, KSAug 4, 1973 · N3365S · Substantial damage