NTSB investigations, TN
6 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1998 | 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\" = 'TN' 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" = 'TN' 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 NYC08LA028Accident · 1 fatalLimited investigationFinal reportBell 407 · Morristown, TNThe pilot's failure to maintain adequate clearance from the idling main rotor blade. Contributing to the accident was the pilot's failure to comply with the manufacturer's procedure for securing the helicopter.NTSB ATL98LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Sewanee, TNThe inadequate visual lookout by the ground pedestrian. A factor was dark night conditions.NTSB ATL95LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Smyrna, TNThe flight instructor's failure to ensure that the magnetos were not energized prior to positioning the propeller, and the dual student's failure to place the ignition switch in the off position after the first start attempt.NTSB ATL92LA034Accident · 1 fatalLimited investigationFinal reportCessna 177B · Memphis, TNThe passenger's failure to follow proper procedures to walk behind the airplane. Factors were the dawn light conditions and the light rain.NTSB ATL84LA170Accident · 1 fatalLimited investigationFinal reportCessna 172N · Nashville, TNThe plt reported that after he & his passengers were aboard the acft, the eng was running & ground control had cleared him to taxi when he discovered that the left main wheel was still chocked, preventing forward movement of the acft. He was setting his…NTSB ATL83LKW02Accident · Serious injuriesFinal reportCessna 152 · Nashville, TNThe acft propeller struck a deplaned female passenger as she proceeded to the front of the acft prior to engine shutdown. The plt stated that his attention was primarily on the fact that the idle RPM seemed high to him and he failed to note his passenger exit…