NTSB investigations, MO
5 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 2 |
| 1990 | 1 |
| 1993 | 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\" = 'MO' 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\" = 370)
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" = 'MO' 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" = 370) 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 CHI93LA120Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Lee'S Summit, MOThe pilot's improper procedures during ground operations.NTSB CHI91LA001Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE Jetstream 3201 · St. Louis, MOVisual outlook inadequate by the ground personnel. Contributing factors were lack of total experience in type of operation and a dusk light condition.NTSB MKC86FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Kansas City, MOThe plt was seen to enter the acft for a short time and then get out, go to the front of the acft and pull down on the prop. The eng fired and the prop struck the pilot's head. A plt who approached the acft moments after the acdt looked into the cockpit and…NTSB MKC85FA175Accident · Serious injuriesField investigationFinal reportCessna 150L · Lee'S Summit, MOThe plt discharged one passenger without stopping the eng & motioned to the next passenger (his wife) to come around from the front of the airplane. Subsequently, his wife walked into the propeller & received a serious injury to her arm.NTSB MKC83FA072Accident · Serious injuriesField investigationFinal reportSwearingen SA 226TC · St. Louis, MORotating right prop struck a female child passenger who had run down the acft airstair to retrieve a doll she had dropped while climbing the airstair to board for the flt. A company attendant was stationed at the left (stopped) prop, but not on or near the…