NTSB investigations: Lycoming IO-360-A1B6D, NY
7 cases on aircraft whose registry engine model is Lycoming IO-360-A1B6D. 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
| 1977 | 2 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 2023 | 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\" = 'NY' 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 ('41593'))
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" = 'NY' 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 ('41593'))
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 ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.NTSB NYC87LA181Accident · No injuriesLimited investigationFinal reportCessna 177RG · Batavia, NYThe flt made an emgy lndg in a corn field after experiencing a loss of eng pwr. During lndg roll the acft collided with a fence. Examination of the propeller revealed that the low pitch stop was broken and had separated from the piston causing the blades to…NTSB NYC86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Farmingdale, NYThe acft collided with trees in the bethpage state park during a rwy 14 ILS apch at republic airport, Farmingdale, NY. The plt had instructed his passenger, a private plt, to report when he had the apch lights in sight. The plt stated the apch was continued…NTSB NYC81FFJ05Accident · No injuriesClosedCessna 177RG · Barre Center, NYNTSB NYC79FFA08Accident · No injuriesClosedCessna 177RG · Hartford, NYNTSB NYC77DFA42Accident · No injuriesClosedCessna 177RG · Kingston, NYNTSB NYC77FFJ41Accident · No injuriesClosedCessna 177RG · Stafford, NY