NTSB investigations, KS
7 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 DEN08IA022Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73F · Wichita, KSFailure of the recirculation fan motor end ball bearing.NTSB DEN03IA101Incident · Minor injuriesIncident investigationFinal reportBoeing 757-200 · Dodge City, KSthe inadvertent activation of the flight deck door's upper pressure relief latch during closure of the door, resulting in the deployment of the upper decompression panel which subsequently struck the captain. Contributing factors included the operator's…NTSB CHI97LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot's decision to perform a precautionary landing in a corn field due to an undetermined event in the cockpit. Factors relating to the accident were: the pilot's inadvertent actuation of the 'smoker' switch, his unfamiliarity with the 'smoke' equipment…NTSB CHI96LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Larned, KSFailure of the pilot to use adequate procedures for hand priming (hand propping) the engine.NTSB CHI96LA025Accident · No injuriesLimited investigationFinal reportBeech A90 · Wichita, KSfailure of the pilot to follow procedures/directives regarding the entrance door, which resulted the door coming open in flight.NTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…NTSB MKC82DA099Accident · Serious injuriesFinal reportCessna 500 · Topeka, KSWhen a passenger was boarding the aircraft, she inadvertently released the latch that held the door open. The door swung toward the closed position, struck the back of the passenger's foot, and severed the tendon. There were thunderstorms in the area and the…