NTSB investigations: Lycoming 0-360-C1F, FL
6 cases on aircraft whose registry engine model is Lycoming 0-360-C1F. 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
| 2000 | 1 |
|---|---|
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 2 |
| 2014 | 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 ('41573'))
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 ('41573'))
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 ERA14LA305Accident · 1 fatalLimited investigationFinal reportChristen Industries A 1 · Tampa, FLThe pilot’s failure to maintain airplane control during initial climb after takeoff, which resulted in an uncontrolled descent into the ground.NTSB NYC08LA060Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Plant City, FLA loss of rotor drive due to excessive slack and breakage of the drive belts. Contributing to the accident was the pilot departing in the helicopter after the rotor engagement time during engine start exceeded the time outlined in the pilot's operating…NTSB NYC07CA132Accident · No injuriesData collectionFinal reportRobinson R-22B · Plant City, FLThe student pilot's failure to maintain directional control. Factors in the accident were variable wind conditions, and soft/uneven terrain.NTSB MIA05CA039Accident · No injuriesData collectionFinal reportRobinson R-22 · Daytona Beach, FLThe improper landing flare by an unknown pilot at an unknown time resulting in a hard landing and substantial damage to the helicopters tailcone.NTSB MIA03CA129Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kissimmee, FLThe inadequate supervision by flight instructor for his failure to prevent incorrect anti-torque pedal input by the student resulting in the helicopter yawing at touchdown. A factor in the accident was the incorrect anti-torque pedal input by the student…NTSB MIA01LA007Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Dellwood, FLthe pilot's failure to clear the area, and his attempted takeoff while the helicopter's right skid was entangled with vines, which resulted in inadvertent dynamic rollover and substantial damage to the aircraft.