NTSB investigations: Lycoming IO-360-A1B6D, MO
8 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
| 1975 | 1 |
|---|---|
| 1977 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 2001 | 1 |
| 2020 | 1 |
| 2021 | 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\" = 'MO' 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" = 'MO' 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 CEN21FA125Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Galt, MOThe pilot’s decision to takeoff into instrument meteorological conditions consisting of low ceilings and icing and his failure to remain clear of terrain while attempting to remain below the clouds, which resulted in impact with terrain.NTSB CEN20LA095Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Chesterfield, MOThe flight instructor’s and student pilot’s failure to ensure that the landing gear was extended before landing.NTSB CHI01LA283Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sikeston, MOThe loss of engine power during the initial climb due to fuel contamination, water. A factor relating to the accident was the trees.NTSB MKC82FA057Accident · 2 fatalField investigationFinal reportCessna 177RG · Ste. Genevieve, MODuring the day of the accident, the pilot received 7 weather briefings which described marginal VFR conditions for his route of flight. At about 1730 CST, he departed Kansas city on a VFR flight plan to farmington, MO. During the flight, he encountered…NTSB MKC79FCG36Accident · No injuriesClosedCessna 177RG · Kansas City, MONTSB MKC77FCG37Accident · No injuriesClosedCessna 177RG · Point Lookout, MONTSB MKC77FCG27Accident · No injuriesClosedCessna 177 · Camdenton, MONTSB MKC76FCG33Accident · No injuriesClosedCessna 177RG · Kansas City, MO