NTSB investigations, NJ
7 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 2 |
| 1993 | 1 |
| 2005 | 1 |
Where
Latest 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\" = 'NJ' 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" = 'NJ' 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 IAD05LA135Accident · Serious injuriesLimited investigationFinal reportSikorsky S-76B · Linden, NJThe lineman's failure to maintain adequate clearance from the main rotor system. A factor was his lack of familiarity with the accident helicopter make and model.NTSB BFO94LA002Accident · 1 fatalLimited investigationFinal reportFairchild SA 227-AC · Newark, NJ1) The failure of the ramp agent to follow proper procedures during the servicing of the airplane, and 2) her lack of attention to the hazards surrounding her. Factors related to the accident are 1) the pressure placed on the ramp agent to rush the servicing…NTSB NYC89LA008Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5B · Wrightstown, NJThe plt said that the battery ran low while he was attempting to start his acft. He said he hand-propped the eng for several minutes and when he became fatigued, the passenger, who is also a pilot, began to hand prop the eng. When the passenger turned the…NTSB NYC88LA065Accident · Serious injuriesLimited investigationFinal reportBell 206 · Holmdel, NJThe pilot had just landed the helicopter from a speed survey of garden state parkway and was in idle. The passenger/police officer deplaned and walked to the rear of the aircraft and was struck by the tail rotor blade receiving serious injuries.NTSB NYC85FA052Accident · 1 fatalField investigationFinal reportHughes 500D · Newark, NJThe right front seat passenger deplaned and walked rearward to retreive his luggage from the left rear seat of the helicopter during the cooling down stage of the engine shutdown. After deplanning he proceeded rearward under the main rotor wash. When rear of…NTSB NYC84LA276Incident · No injuriesLimited investigationFinal reportCessna 310II · Newark, NJAn unemployed person was trying to help load an acft. In noticing that a bill of laden had been left off the cargo he ran toward the acft which had, by this time, started engines. The plt said he saw the running man and shoved the mixtures to cut off the…NTSB NYC84FHD04Accident · Serious injuriesFinal reportMooney M20 · Atlantic City, NJThe flt to Atlantic-city-bader field was uneventful, except the acft touched down hard during the landing. The plt taxied to the terminal & parked with the exit door facing the terminal. He elected not to shut down the eng since he intended to immediately…