NTSB investigations: Mcculloch 4318A&E/0-100, FL
5 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
| 1976 | 1 |
|---|---|
| 1978 | 1 |
| 1984 | 1 |
| 1988 | 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\" = 'FL' 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" = 'FL' 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 ATL98LA097Accident · Minor injuriesLimited investigationFinal reportBenson B-8M · Placida, FLExcessive taxi speed. A related factor was the wind gusts.NTSB MIA89LA020Accident · Minor injuriesLimited investigationFinal reportParsons B-8M · Lake City, FLDuring an airshow, the plt took off to perform a planned 8-spin autorotative landing from an alt of aprx 800 ft. an FAA inspector who observed the accident stated the flt ascended to aprx 650 ft MSL. After closing the throttle, the plt began the maneuver.…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…NTSB MIA78FLA50Accident · 1 fatalClosedBirdman TL1A · Deland, FLNTSB MIA76DLD59Accident · Serious injuriesClosedBelden B-8M · Mulberry, FL