NTSB investigations: Texas Helicopter OH-13H/M74A, CA
11 cases on aircraft the registry lists as Texas Helicopter OH-13H/M74A. 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1998 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8930105'))
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" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8930105'))
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 LAX98LA309Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Gilroy, CAThe pilot's loss of control for undetermined reasons.NTSB LAX92LA345Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Merced, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Contributing to this accident was fuel exhaustion and the cultivated soft field.NTSB LAX91LA351Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter M74L · Lodi, CAThe inflight loss of control by the pilot for undetermined reasons.NTSB LAX88DUQ04Accident · No injuriesFinal reportTexas Helicopter M74A · Lancaster, CADuring an aerial application flight, just after takeoff, the nose of the helicopter suddenly pitched up. The pilot reduced power to keep from climbing. The fore/aft cyclic control had no effect. The helicopter settled to the ground resulting in substantial…NTSB LAX88DVD01Accident · No injuriesFinal reportTexas Helicopter Wasp/M74L · Petaluma, CADuring an aerial application flight, while on the last pass, the aircraft struck a power line that became entangled in the rotor blades. The pilot was unable to maintain control of the aircraft and collided with the terrain. There were no reported mechanical…NTSB LAX86LA283Accident · Serious injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M · Valencia, CAThe pilot reported that he heard a loud bang and grinding noise from the engine/main transmission area while on a swath run. He stated that the main rotor RPM decayed immediately after he heard the noise. As the helicopter descended to about 50 feet above the…NTSB LAX86LUG01Accident · No injuriesFinal reportTexas Helicopter M74A · Daggett, CAThe plt stated he had just lifted off for a fertilizer spreading operation with an external load bucket, when the eng had a partial pwr loss at 100 ft AGL. A descent was started and the bucket was disengaged. However, while the plt was attempting to land the…NTSB LAX81DUQ26Accident · No injuriesClosedTexas Hel M74A · Rosamond, CANTSB LAX80FVM37Accident · 1 fatalClosedTexas Hel OH-13H · Salinas, CANTSB OAK79DVG53Accident · No injuriesClosedBell OH-13H · Napa, CANTSB OAK78FVA85Accident · No injuriesClosedBell H13H · Firebaugh, CA