NTSB investigations, PA
6 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1993 | 2 |
| 2001 | 1 |
| 2002 | 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\" = 'PA' 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\" = 100)
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" = 'PA' 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" = 100) 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 IAD02LA071Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Unionville, PAThe pilot's evasive maneuver to avoid a collision with a departing airplane, which resulted in a landing short of the runway. A factor was the pilot's decision to land on the runway opposite the one in use.NTSB NYC01FA223Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bern Township, PAThe pilot's loss of control for undetermined reasons, which resulted in a high speed dive to the ground.NTSB NYC94FA040Accident · 2 fatalField investigationFinal reportAero Commander 500A · White Mills, PAwas the fracture and separation of the airplane wing, and the subsequent loss of control and collision with trees, as a result of the pilot's repeated performance of acrobatic maneuvers, which exceeded the design limits of the airplane.NTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.NTSB NYC84LA285Accident · No injuriesLimited investigationFinal reportNavion Navion · Brodheadsville, PAShortly after takeoff pilot was advised of model aircraft in flight path, evasive action taken, however, presence of model not confirmed. Pilot reduced pwr below recommeded RPM causing aircraft to settle. Pilot then applied pwr to avoid collision with trees.…NTSB NYC83FA102Accident · 2 fatalField investigationFinal reportHiller FH-1100 · Gettysburg, PAThe plt took off on a flt to york, PA to refuel the helicopter & to demonstrate it to a prospective buyer while en route. Witnesses observed the helicopter shortly after departure. Two of 4 witnesses heard a change in the sound of the helicopter, 2 witnesses…