NTSB investigations: Mcculloch 4318A&E/0-100, CA
15 cases on aircraft whose registry engine model is Mcculloch 4318A&E/0-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
| 1965 | 1 |
|---|---|
| 1967 | 3 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1992 | 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.engine_model_code IN ('43101'))
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.engine_model_code IN ('43101'))
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 LAX92LA109Accident · 1 fatalLimited investigationFinal report85 Manista KB-2 · Rosamond, CAThe pilot's failure to maintain main rotor RPM adequate to avoid flapping. Factors which contributed to the accident were related to the pilot's performance of an excessively abrupt maneuver.NTSB LAX84FUG02Accident · 1 fatalFinal reportPhaneuf B8 MOD Gyro · Murrieta, CAA witness observed the gyrocopter circle the aprt. On the second time around, it dropped down low on the downwind leg and disappeared behind a small hill. He also stated the eng was running at full power and that he could hear the rotor blades strike the…NTSB OAK78DVA42Accident · No injuriesClosedBensen B8M · Fresno, CANTSB OAK76DVM38Accident · No injuriesClosedBensen B8M · Salinas, CANTSB LAX76DUM11Accident · Minor injuriesClosedBensen B8M · San Diego, CANTSB LAX75FUA01Accident · Minor injuriesClosedBensen B-8 · Corona, CANTSB LAX74DUG42Accident · 1 fatalClosedBensen B8M · Corona, CANTSB LAX73DUG37Accident · Serious injuriesClosedBensen B-8M · Adelanto, CANTSB LAX71FUQ69Accident · No injuriesClosedBensen B-8 · Tehachapi, CANTSB LAX70FUGU9Accident · Serious injuriesClosedBensen B8-M · Hemet, CANTSB LAX69D0057Accident · No injuriesClosedBensen B-8M · Shafter, CANTSB LAX68A0062Accident · Minor injuriesClosedBensen B8M · Rialto, CANTSB LAX67A0100Accident · No injuriesClosedBensen B-8M · George Afb, CANTSB LAX67A0070Accident · 1 fatalClosedBensen B-8M · Chino, CANTSB OAK66A0013Accident · 1 fatalClosedBreeze H1 · Lincoln, CA