NTSB investigations: GE AV H80-100
4 cases on aircraft whose registry engine model is GE AV H80-100. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2020 | 2 |
|---|---|
| 2022 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30170'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('30170'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Aurora, MOThe pilot did not ensure clearance from a power line during a surveillance pass of a field to be sprayed.NTSB ERA22LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hawkinsville, GAA failure of the electric main fuel pump due to the carbon brushes having completely worn away.NTSB ENG20LA046Incident · No injuriesClass 3 · LimitedFinal reportThrush S2R-H80 · Donalsonville, GAA total loss of engine power due to a loose torque meter attachment nut in the reduction gearbox that jammed the planetary gearset causing the power turbine shaft to separate from the power turbine disk, resulting in the power turbine overspeeding and…NTSB ERA20LA306Accident · Serious injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Hawkinsville, GAThe pilot's failure to maintain clearance from an antenna tower while maneuvering during an agricultural application flight while flying directly toward the sun.