NTSB investigations, OH
8 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1982 | 2 |
|---|---|
| 1985 | 3 |
| 1988 | 1 |
| 1995 | 1 |
| 1996 | 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\" = 'OH' 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" = 'OH' 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 IAD96LA137Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Waterford, OHthe pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.NTSB NYC95DEI01Accident · 1 fatalFinal reportStaudacher S-600 · Wellington, OHloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall and collision with the ground.NTSB ATL88FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Ravenna, OHNTSB CHI85FA218Accident · Serious injuriesField investigationFinal reportCessna 425 · Dayton, OHThe acft involved was experimentally configured with 4-bladed props and was on a test flt to determine handling characteristics following a throttle chop to idle power at 50 ft AGL. This maneuver had been accomplished twice on the test flt without incident.…NTSB CHI85LA181Accident · No injuriesLimited investigationFinal reportCessna 172N · Perrysville, OHAcft landed with quartering tailwind. Acft touched down, ballooned and touched down again with aprx 1000 ft of rwy remaining. Unable to stop on the tall wet grass, plt initiated a groundloop to the left into a plowed field. The acft then nosed over.NTSB CHI85FA121Accident · 4 fatalField investigationFinal reportMooney M20K · Coldwater, OHThe flight departed without a pre-flight inspection, engine run up, or radio call on UNICOM. The aircraft was observed doing low altitude aerobatic maneuvers. Witnesses observed the aircraft nose over and impact the ground in a near vertica attitude from…NTSB CHI82DEG03Accident · Serious injuriesFinal reportBenson B8M · Hamilton, OHThe gyrocopter pilot initiated a takeoff from the grass media between the taxiway and runway 29. After lifting off, he climbed to an altitude of about 40 to 50 ft, then turned toward the runway. At about the same time, a Piper PA-28 was taking off on the…NTSB CHI82DA065Accident · No injuriesFinal reportPiper PA-38-112 · Elyria, OHDuring the landing flare the student overcorrected with full aft elevator. The aircraft pitched up, the instructor applied full power, and the aircraft bounced and drifted into a snow bank. The instructor was reported to have about 20 hours instructing.