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 MKC77FCQ56Accident · No injuriesClosedBeech T34A · Johnson, KSAug 30, 1977 · N1115V · Substantial damage NTSB MKC77FCG51Accident · No injuriesClosedBeech A23-19 · Lyndon, KSAug 28, 1977 · N4746J · Substantial damage NTSB MKC77FCG50Accident · No injuriesClosedCessna 150E · Topeka, KSAug 27, 1977 · N3062J · Substantial damage NTSB MKC77FCG46Accident · Minor injuriesClosedCessna 172 · Topeka, KSAug 14, 1977 · N3871Q · Substantial damage NTSB MKC77DCQ55Accident · No injuriesClosedPiper PA-18 · Manhatton, KSAug 13, 1977 · N217T · Substantial damage NTSB MKC77DCQ53Accident · No injuriesClosedCessna 172 · Benton, KSAug 10, 1977 · N9621H · Substantial damage NTSB MKC77DCQ52Accident · No injuriesClosedCessna 188 · Meade, KSAug 8, 1977 · N9899V · Substantial damage NTSB MKC77DCQ51Accident · No injuriesClosedCessna 150 · Greensburg, KSAug 8, 1977 · N11619 · Substantial damage NTSB MKC77DCQ50Accident · No injuriesClosedCessna 172 · Oakley, KSAug 8, 1977 · N736RM · Substantial damage NTSB MKC77FCQ49Accident · Minor injuriesClosedPiper PA-22 · Larned, KSJul 25, 1977 · N3659A · Substantial damage NTSB MKC77FCG38Accident · No injuriesClosedCessna 188 · De Soto, KSJul 17, 1977 · N21691 · Substantial damage NTSB MKC77FCQ48Accident · Minor injuriesClosedHughes 269A · Herndon, KSJul 15, 1977 · N8892F · Substantial damage NTSB MKC77DCQ54Accident · No injuriesClosedCessna 210 · Paxico, KSJul 15, 1977 · N9501T · Substantial damage NTSB MKC77DCQ47Accident · Minor injuriesClosedPiper PA-28 · Hoxie, KSJul 14, 1977 · N7221F · Substantial damage NTSB MKC77FCQ46Accident · Minor injuriesClosedCessna U206G · Wichita, KSJul 10, 1977 · N7711N · Substantial damage NTSB MKC77FCQ44Accident · No injuriesClosedGrumman G-164A · Junction City, KSJun 27, 1977 · N5396 · Substantial damage NTSB MKC77FCQ45Accident · No injuriesClosedCessna 210B · Mullinville, KSJun 26, 1977 · N9723X · Substantial damage NTSB MKC77FCG31Accident · No injuriesClosedCessna 177RG · Gardner, KSJun 25, 1977 · N1927Q · Substantial damage NTSB MKC77FCQ43Accident · No injuriesClosedPiper PA-30 · Wichita, KSJun 24, 1977 · N8695Y · Substantial damage NTSB MKC77DCG34Accident · No injuriesClosedCessna 182 · Kansas City, KSJun 17, 1977 · N8358S · Substantial damage NTSB MKC77FCQ42Accident · 1 fatalClosedCessna 188B · Olsburg, KSJun 16, 1977 · N4809Q · Destroyed NTSB MKC77FCQ41Accident · No injuriesClosedPiper PA-23 · Minneapolis, KSJun 15, 1977 · N54797 · Destroyed NTSB MKC77DCG30Accident · Serious injuriesClosedPiper PA-22 · Leavenworth, KSJun 13, 1977 · N2656P · Substantial damage NTSB MKC77DCG29Accident · No injuriesClosedHuey-Smith H-1 · Eudora, KSJun 12, 1977 · N88C · Substantial damage NTSB MKC77FCQ40Accident · No injuriesClosedTaylorcraft DCO-65 · Salina, KSJun 5, 1977 · N50373 · Substantial damage NTSB MKC77DCQ39Accident · No injuriesClosedPiper PA-28 · Yates Center, KSJun 5, 1977 · N9736W · Substantial damage NTSB MKC77DCQ38Accident · Minor injuriesClosedCessna 150 · Maize, KSMay 29, 1977 · N11550 · Substantial damage NTSB MKC77DEQ36Accident · No injuriesClosedCessna 182 · Derby, KSMay 21, 1977 · N2445R · Substantial damage NTSB MKC77FCG23Accident · No injuriesClosedPitts S1S · Olathe, KSMay 18, 1977 · N9TJ · Substantial damage NTSB MKC77FCQ34Accident · No injuriesClosedPiper PA-25 · Benton, KSMay 12, 1977 · N9783P · Substantial damage NTSB MKC77DCQ37Accident · No injuriesClosedHiller FH1100 · Oakley, KSMay 11, 1977 · N5073F · Substantial damage NTSB MKC77OCQ33Accident · No injuriesClosedCessna 172H · Fall River, KSMay 8, 1977 · N3803R · Substantial damage NTSB MKC77FCQ31Accident · No injuriesClosedGrumman G-164A · Concordia, KSApr 27, 1977 · N6533 · Substantial damage NTSB MKC77FCG21Accident · No injuriesClosedPiper PA-24 · Osawatomie, KSApr 27, 1977 · N5454P · Substantial damage NTSB MKC77DCG19Accident · No injuriesClosedPiper PA-28 · Ft Leavenworth, KSApr 24, 1977 · N562FL · Destroyed NTSB MKC77FCQ30Accident · Minor injuriesClosedCessna 172M · Iola, KSApr 21, 1977 · N80506 · Substantial damage NTSB MKC77FA020Accident · No injuriesClosedCessna 320C · Osborne, KSApr 20, 1977 · N48325 · Substantial damage NTSB MKC77DCQ32Accident · No injuriesClosedCessna 188 · Cawker City, KSApr 19, 1977 · N53376 · Substantial damage NTSB MKC77FCQ29Accident · Serious injuriesClosedGrum Amer AA1-A · Junction City, KSApr 15, 1977 · N9217L · Substantial damage NTSB MKC77DCQ28Accident · No injuriesClosedCessna 140 · Kirwin, KSApr 7, 1977 · N89560 · Substantial damage NTSB MKC77FCQ27Accident · No injuriesClosedCessna 182 · Wichita, KSApr 4, 1977 · N92015 · Substantial damage NTSB MKC77FCG17Accident · No injuriesClosedCessna 150M · Olathe, KSMar 23, 1977 · N704FX · Substantial damage NTSB MKC77DCQ26Accident · No injuriesClosedPiper PA-22 · Hays, KSMar 19, 1977 · N3513P · Substantial damage NTSB MKC77DCQ25Accident · Minor injuriesClosedPiper PA-28 · Wakeeney, KSMar 18, 1977 · N7221W · Substantial damage NTSB MKC77FCQ24Accident · Minor injuriesClosedCessna 150M · Junction City, KSMar 15, 1977 · N704AJ · Destroyed NTSB MKC77DCQ23Accident · No injuriesClosedCessna 180 · Russell, KSMar 14, 1977 · N7668K · Destroyed NTSB MKC77DCQ22Accident · No injuriesClosedCessna 172 · Coats, KSMar 10, 1977 · N5461Q · Substantial damage NTSB MKC77DCQ21Accident · No injuriesClosedCessna 150 · Manhattan, KSMar 7, 1977 · N16014 · Substantial damage NTSB MKC77DCQ35Accident · No injuriesClosedLuscombe 8A · Colby, KSMar 6, 1977 · N1134B · Substantial damage NTSB MKC77DCG16Accident · No injuriesClosedCessna 182 · Olathe, KSMar 3, 1977 · N52367 · Substantial damage