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 MKC70D0093Accident · Serious injuriesClosedCessna 177 · Stanley, KSJul 3, 1969 · N3494T · Substantial damage NTSB MKC70D0097Accident · Minor injuriesClosedCessna 150 · Valley Falls, KSJul 2, 1969 · N3073X · Destroyed NTSB MKC70F0029Accident · Minor injuriesClosedCessna 310P · Wichita, KSJun 27, 1969 · N5879M · Destroyed NTSB MKC70D0006Accident · No injuriesClosedCessna 177 · Wichita, KSJun 27, 1969 · N3215T · Substantial damage NTSB MKC70D0080Accident · Minor injuriesClosedCallair A-9 · Cimarron, KSJun 26, 1969 · N3610G · Destroyed NTSB MKC70D0063Accident · No injuriesClosedWaco EGC-8 · Kansas City, KSJun 23, 1969 · N2334 · Substantial damage NTSB MKC69A0063Accident · 2 fatalClosedTaylorcraft BC-12D · Kingman, KSJun 19, 1969 · N95171 · Destroyed NTSB MKC70D0060Accident · No injuriesClosedPiper PA-28 · Olathe, KSJun 18, 1969 · N9418W · Substantial damage NTSB MKC70D0051Accident · No injuriesClosedPiper PA-22 · Rantoul, KSJun 16, 1969 · N8035D · Substantial damage NTSB MKC70F0090Accident · 1 fatalClosedPiper PA-28 · Kansas City, KSJun 9, 1969 · N5996W · Destroyed NTSB MKC70D0017Accident · No injuriesClosedPiper PA-25 · Burlington, KSJun 7, 1969 · N6810Z · Substantial damage NTSB MKC69D0464Accident · Minor injuriesClosedCessna 175 · Washington, KSJun 1, 1969 · N7511M · Substantial damage NTSB MKC70F0064Accident · No injuriesClosedBeech G35 · Leawood, KSMay 30, 1969 · N4434L · Substantial damage NTSB MKC70D0033Accident · No injuriesClosedCessna 150 · Leawood, KSMay 30, 1969 · N2494J · Substantial damage NTSB MKC70D0001Accident · Minor injuriesClosedCessna 150 · Ottawa, KSMay 25, 1969 · N3791J · Substantial damage NTSB MKC69A0061Accident · 4 fatalClosedBeech K35 · Sylvan Grove, KSMay 25, 1969 · N3065C · Destroyed NTSB MKC69D0458Accident · No injuriesClosedCessna 172H · Manhattan, KSMay 21, 1969 · N2663L · Substantial damage NTSB MKC70F0042Accident · Minor injuriesClosedPiper PA-28R · Olathe, KSMay 15, 1969 · N7684J · Substantial damage NTSB MKC69D0441Accident · No injuriesClosedBoeing A75 · Axtell, KSMay 15, 1969 · N122P · Substantial damage NTSB MKC69D0449Accident · No injuriesClosedCessna 182K · Augusta, KSMay 12, 1969 · N3103F · Substantial damage NTSB MKC70D0018Accident · Minor injuriesClosedPiper PA-28 · Elmo, KSMay 10, 1969 · N5764W · Substantial damage NTSB MKC69F0420Accident · No injuriesClosedPiper PA-28 · Kanapolis, KSMay 10, 1969 · N8048N · Substantial damage NTSB MKC69D0437Accident · No injuriesClosedCessna 182F · Wamego, KSMay 9, 1969 · N3562U · Substantial damage NTSB MKC69D0418Accident · No injuriesClosedPiper PA-32 · Marysville, KSMay 9, 1969 · N4140R · Substantial damage NTSB MKC69A0057Accident · 1 fatalClosedMooney M20F · Plainville, KSMay 5, 1969 · N9201M · Destroyed NTSB MKC69D0473Accident · No injuriesClosedCessna 210D · Kiowa, KSMay 4, 1969 · N3890Y · Substantial damage NTSB MKC69D0411Accident · No injuriesClosedCessna 182M · Wichita, KSMay 2, 1969 · N70697 · Substantial damage NTSB MKC69D0456Accident · No injuriesClosedPiper PA-28 · Ellinwood, KSApr 23, 1969 · N6272W · Substantial damage NTSB MKC69D0436Accident · No injuriesClosedPiper J3C-65 · Olathe, KSApr 13, 1969 · N65042 · 2 aircraft · Substantial damage NTSB MKC69D0387Accident · No injuriesClosedCessna 177 · Pratt, KSApr 13, 1969 · N3273T · Substantial damage NTSB MKC69F0401Accident · Serious injuriesClosedCessna 177 · Jennings, KSApr 2, 1969 · N2367Y · Substantial damage NTSB MKC69F0372Accident · Serious injuriesClosedLuscombe 8E · Wichita, KSApr 2, 1969 · N1655K · Destroyed NTSB MKC69D0388Accident · No injuriesClosedPiper PA-25 · Colby, KSMar 31, 1969 · N4927Y · Substantial damage NTSB MKC69D0367Accident · No injuriesClosedCessna 150J · Johnson, KSMar 31, 1969 · N51024 · Substantial damage NTSB MKC69D0431Accident · No injuriesClosedCessna 150 · Stilwell, KSMar 27, 1969 · N3454J · Substantial damage NTSB MKC69D0377Accident · No injuriesClosedCessna 337 · Council Grove, KSMar 27, 1969 · N6313F · Substantial damage NTSB MKC69F0356Accident · Minor injuriesClosedCessna 210 · Augusta, KSMar 21, 1969 · N9429T · Substantial damage NTSB MKC69D0383Accident · No injuriesClosedCessna 170B · Ulysses, KSMar 21, 1969 · N4502C · Substantial damage NTSB MKC69D0430Accident · No injuriesClosedCessna 182B · Bonner Sprgs, KSMar 20, 1969 · N2517G · Substantial damage NTSB MKC69A0053Accident · 3 fatalClosedCessna 150H · Kansas City, KSMar 19, 1969 · N22790 · 2 aircraft · Destroyed NTSB MKC69D0393Accident · No injuriesClosedErco 415-C · Leawood, KSMar 12, 1969 · N94710 · Substantial damage NTSB MKC69D0366Accident · No injuriesClosedCessna 150G · Bonner Sprgs, KSMar 9, 1969 · N4673X · Substantial damage NTSB MKC69D0342Accident · No injuriesClosedCessna 182 · Leawood, KSMar 5, 1969 · N3139R · Substantial damage NTSB MKC69D0360Accident · No injuriesClosedCessna 175 · Colby, KSMar 1, 1969 · N6685E · Substantial damage NTSB MKC69F0341Accident · Serious injuriesClosedCessna 150 · Dodge City, KSFeb 26, 1969 · N5513E · Destroyed NTSB MKC69F0357Accident · No injuriesClosedPiper PA-22 · Lawrence, KSFeb 18, 1969 · N8035D · Substantial damage NTSB MKC69A0050Accident · 2 fatalClosedPiper PA-22 · Oswego, KSFeb 16, 1969 · N1816P · Destroyed NTSB MKC69F0362Accident · No injuriesClosedCessna 421A · Wichita, KSFeb 14, 1969 · N2241Q · Substantial damage NTSB MKC69F0364Accident · No injuriesClosedCessna 337A · Meade, KSFeb 12, 1969 · N5358S · Substantial damage NTSB MKC69F0336Accident · No injuriesClosedCessna 150E · Johnson, KSFeb 10, 1969 · N8294S · Substantial damage