NTSB investigations, TX
18 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 2004 | 1 |
| 2007 | 3 |
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\" = 'TX' 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" = 'TX' 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 DFW07IA193Incident · 1 fatalIncident investigationFinal reportCessna A188B · Colorado City, TXThe pilot's failure to maintain clear of the rotating propeller.NTSB DFW07CA189Accident · Serious injuriesData collectionFinal reportMitsubishi MU-2B-36 · Hobby Airport, TXThe failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.NTSB DFW07CA069Accident · Serious injuriesData collectionFinal reportCessna 172 · Lancaster, TXThe spectator's inadvertent contact with the turning propeller while the airplane was standing with the engine operating. A contributing factor was the dark night conditions.NTSB DFW05LA010Accident · Serious injuriesLimited investigationFinal reportSaab-Scania SF-340B · Fort Worth, TXThe ground personnel's failure to maintain clearance from the propeller. Contributing factors were the ground personnel's failure to comply with procedures/directives and the ground personnel's failure to properly use equipment.NTSB FTW96LA161Accident · 1 fatalLimited investigationFinal reportBensen Gyroplane · Carthage, TXthe pilot's inadequate coordination with the spectator, concerning the spectator's need to remain clear of the takeoff area, and the spectator's failure to remain clear of the takeoff area. A factor relating to the accident was: the spectator's distorted…NTSB FTW96LA142Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Jasper, TXFailure of the pilot to ensure that the other person (outside the airplane) remained clear of the operating propeller, and failure of the other person to maintain awareness of the hazardous condition. A factor relating to the accident was: the other person…NTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.NTSB FTW95LA100Accident · 1 fatalLimited investigationFinal reportCessna A152 · Houston, TXThe pilot's inadequate supervision of the passenger. A factor was the pilot's inadequate preflight of the aircraft.NTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.NTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.NTSB FTW91LA163Accident · 1 fatalLimited investigationFinal reportChampion 7-GCB · Frankston, TXThe ground person did not understand the verbal instructions.NTSB FTW87LA015Accident · Serious injuriesLimited investigationFinal reportHouk Pitts S1-S · La Porte, TXA mechanic was attempting to pull the prop through one revolution prior to starting the engine on a pitts S1-S. Due to a bad p-lead on the magneto's the engine fired, causing the prop to strike the right leg of the mechanic. The mechanics leg was amputated…NTSB FTW86LRA10Accident · Serious injuriesFinal reportCessna 150L · Houston, TXThe acft failed to start so the CFI got out to turn the prop. The mag switch was left on and the eng fired as the CFI moved the prop blade. The CFI was struck by the blade and serously injured.NTSB FTW85LA313Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Follett, TXThe passenger had deplaned to remove unnecessary articles from the aircraft and apparently was not cautioned by the PIC to be careful of the rotating propeller. As she returned to the aircraft to re-board she walked into the observed rotating propeller and…NTSB FTW84LA259Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Andrews, TXThe pilot stated that the helicopter was operating at 55 percent power on the gnd while awaiting the pax to board. The passenger walked into the tailrotor and received serious injuries. The plt stated that the company does not have safety procedures for…NTSB FTW83LA177Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Mckinney, TXThree observers accompanied the aircrew & other passengers on a flt to transport skydivers aloft. Prior to the flt, all 3 of the observers were briefed not to exit the acft until the engines were secured. However, 1 of the 3 discussed the need to move a…NTSB FTW82DRA26Accident · Serious injuriesFinal reportCessna 150 · Friendswood, TXThe pilot of N150WM was giving free rides to guests. He taxied to the active runway after a landing and discharged a passenger. A female passenger walked out to the airplane to get in but due to the fact she had previously rode, the pilot asked her to let…NTSB FTW82FRA25Accident · Serious injuriesFinal reportCessna 177RG · Houston, TXAfter returning from a short cross-country, the pilot taxied to his parking spot. His car was park on one side of the aircraft's parking spot and another car was on the opposite side. The pilot's wife deplaned to move his car while the aircraft engine was…