NTSB investigations: Mcculloch 4318A&E/0-100, 1984
3 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
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 4 |
| 1967 | 6 |
| 1968 | 9 |
| 1969 | 2 |
| 1970 | 6 |
| 1971 | 5 |
| 1972 | 6 |
| 1973 | 1 |
| 1974 | 5 |
| 1975 | 4 |
| 1976 | 4 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 7 |
| 1981 | 3 |
| 1982 | 4 |
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2006 | 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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984
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 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 CHI84LA347Accident · No injuriesLimited investigationFinal reportLindsay Davis Benson B8M · Gross Ile, MIThe student pilot was in the airport traffic pattern when he noticed the eng cylinder head temp exceeding the red line. He attempted to lower the temp by reducing the eng RPM but could not maintain alt. The pilot maneuvered the acft toward the airport and at…NTSB MIA84FA112Accident · 1 fatalField investigationFinal reportSwanson/Bensen B-8M · Dunnellon, FLThe student plt was told by the owner of the acft to only taxi the acft & not to fly it. During the 6th taxi maneuver it became airborne. It climbed to about 200 ft AGL where the plt made a 180 deg turn, followed by a 90 deg turn, followed by another 180 deg…