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 MKC72DCQ48Accident · Minor injuriesClosedPiper PA-28 · Lamar, KSMar 31, 1972 · N1962T · Substantial damage NTSB MKC72DCQ47Accident · Minor injuriesClosedCessna 172H · Emporia, KSMar 26, 1972 · N1499F · Substantial damage NTSB MKC72FCQ46Accident · No injuriesClosedLuscombe 8A · Hutchinson, KSMar 21, 1972 · N71345 · Substantial damage NTSB MKC72FCG45Accident · No injuriesClosedCessna 180 · Edgerton, KSMar 18, 1972 · N3679C · Substantial damage NTSB MKC72DCQ45Accident · Minor injuriesClosedErcoupe 415C · Minneapolis, KSMar 14, 1972 · N99130 · Substantial damage NTSB MKC72DCQ43Accident · Minor injuriesClosedPiper PA-22 · Lakin, KSMar 12, 1972 · N8623D · Substantial damage NTSB MKC72AK055Accident · 1 fatalClosedCessna 177B · Conway Sprgs, KSMar 9, 1972 · N30816 · Destroyed NTSB MKC72DCG38Accident · No injuriesClosedCessna 172K · Stanley, KSMar 5, 1972 · N84656 · Substantial damage NTSB MKC72IK050Incident · No injuriesClosedBellanca 17-30 · Salina, KSFeb 22, 1972 · N8867R · Minor damage NTSB MKC72IK048Incident · Minor injuriesClosedBritish AC 1-11 · Wichita, KSFeb 18, 1972 · N1545 · No damage NTSB MKC72DCQ47Accident · No injuriesClosedCessna 120 · Beaumont, KSFeb 13, 1972 · N33Y · Substantial damage NTSB MKC72DCQ41Accident · No injuriesClosedMotor Spatz SF24 · Dodge City, KSFeb 13, 1972 · N41FA · Substantial damage NTSB MKC72FCQ40Accident · No injuriesClosedCessna P206B · Leoti, KSFeb 11, 1972 · N979MD · Substantial damage NTSB MKC72DCQ38Accident · No injuriesClosedCessna 182L · Wichita, KSFeb 5, 1972 · N3440R · Substantial damage NTSB MKC72DCQ39Accident · No injuriesClosedPiper PA-28 · Wichita, KSJan 30, 1972 · N5888U · Substantial damage NTSB MKC72AK046Accident · Serious injuriesClosedPiper PA-15 · Great Bend, KSJan 30, 1972 · N4451H · 2 aircraft · Destroyed NTSB MKC72DCQ44Accident · No injuriesClosedCessna 182K · Colby, KSJan 29, 1972 · N2998R · Substantial damage NTSB DEN72AD031Accident · Serious injuriesClosedBoeing 727 · Hill City, KSJan 10, 1972 · N7277F · No damage NTSB MKC72AK040Accident · 2 fatalClosedCessna 150L · Clay Center, KSDec 25, 1971 · N1776Q · Destroyed NTSB MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSDec 19, 1971 · N7436M · Destroyed NTSB MKC72DCQ37Accident · No injuriesClosedCessna 150L · Clay Center, KSDec 16, 1971 · N1248Q · Substantial damage NTSB MKC72AK036Accident · No injuriesClosedPiper PA-32 · Topeka, KSDec 15, 1971 · N4105W · Substantial damage NTSB MKC72AK030Accident · 4 fatalClosedBeech E35 · Garden City, KSNov 24, 1971 · N3202C · Destroyed NTSB MKC72FCQ36Accident · Minor injuriesClosedBeech 35 · Junction Cty, KSNov 22, 1971 · N735JS · Substantial damage NTSB MKC72FCG34Accident · 1 fatalClosedPiper PA-22 · Lansing, KSNov 22, 1971 · N1792P · Substantial damage NTSB MKC72FCQ34Accident · No injuriesClosedCessna 180 · Valley Cntr, KSNov 14, 1971 · N2204C · Substantial damage NTSB MKC72FCQ33Accident · No injuriesClosedCessna 170B · Wichita, KSNov 11, 1971 · N1660D · Substantial damage NTSB MKC72FCQ32Accident · No injuriesClosedCessna 182N · Wichita, KSNov 10, 1971 · N8964G · Substantial damage NTSB MKC72DCQ31Accident · No injuriesClosedBeech B95 · Salina, KSOct 28, 1971 · N9629R · Substantial damage NTSB MKC72DCQ35Accident · No injuriesClosedDouglas A-26C · Hutchinson, KSOct 20, 1971 · N6841D · Substantial damage NTSB MKC72AK028Accident · 3 fatalClosedCessna 182J · Longton, KSOct 20, 1971 · N2784F · Destroyed NTSB MKC72DCG29Accident · Serious injuriesClosedCessna 150 · Leawood, KSOct 17, 1971 · N2494J · No damage NTSB MKC72AK027Accident · 2 fatalClosedErco 415-C · Topeka, KSOct 16, 1971 · N37106 · Destroyed NTSB MKC72DCG26Accident · No injuriesClosedBeech G35 · Leawood, KSOct 14, 1971 · N4587D · Substantial damage NTSB MKC72AK026Accident · 3 fatalClosedBeech S35 · Topeka, KSOct 8, 1971 · N5883S · 2 aircraft · Destroyed NTSB MKC72DCQ30Accident · Minor injuriesClosedCessna 170B · Wilson, KSOct 7, 1971 · N2727D · Substantial damage NTSB MKC72FCQ29Accident · No injuriesClosedCessna 140 · Mcdonald, KSSep 27, 1971 · N4283N · Substantial damage NTSB MKC72AK020Accident · 2 fatalClosedAmer Avco AA1 · Potwin, KSSep 25, 1971 · N5770L · Destroyed NTSB MKC71DCQ28Accident · No injuriesClosedMinicab GY-20 · Goodland, KSSep 19, 1971 · N6824D · Substantial damage NTSB MKC72DCG21Accident · Minor injuriesClosedCessna 172 · Topeka, KSSep 12, 1971 · N1345Y · Substantial damage NTSB MKC72DCQ26Accident · No injuriesClosedPiper PA-25 · Richfield, KSSep 9, 1971 · N8829L · Substantial damage NTSB MKC72FCQ24Accident · No injuriesClosedCessna 182J · Arkansas Cty, KSSep 4, 1971 · N3596F · Substantial damage NTSB MKC72DCQ27Accident · No injuriesClosedMaule M-4 · Newton, KSSep 4, 1971 · N40307 · Substantial damage NTSB MKC72DCQ23Accident · No injuriesClosedCessna 150 · Med Lodge, KSAug 30, 1971 · N3915U · Substantial damage NTSB MKC72DCQ25Accident · No injuriesClosedCessna 421A · Wichita, KSAug 26, 1971 · N2243Q · Substantial damage NTSB MKC72DCQ21Accident · No injuriesClosedBeech M35 · Goddard, KSAug 22, 1971 · N9839R · Substantial damage NTSB MKC72AK016Accident · 1 fatalClosedCessna 150B · Victoria, KSAug 21, 1971 · N1291Y · Destroyed NTSB MKC72FCQ20Accident · Serious injuriesClosedPiper PA-28 · Hutchinson, KSAug 17, 1971 · N1299G · Minor damage NTSB MKC72AK015Accident · 2 fatalClosedAeronca 11AC · Admire, KSAug 16, 1971 · N86032 · Destroyed NTSB MKC72DCQ19Accident · No injuriesClosedBeech 35 · Derby, KSAug 15, 1971 · N4474V · Substantial damage