NTSB investigations: Lycoming O-320-A2B
4 cases on aircraft whose registry engine model is Lycoming O-320-A2B, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1994 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42101')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42101')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 ANC07LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot's failure to maintain adequate airspeed to preclude a stall while maneuvering, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors contributing to the accident were variable wind conditions, and an inadvertent…NTSB ANC94LA141Accident · Serious injuriesLimited investigationFinal reportArtic S-1B2 · Wasilla, AKA failure of the pilot to maintain adequate airspeed. A lack of total aeronautical experience was a factor in the accident.NTSB ANC87LA058Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe pilot reported that he could not keep the ski equipped aircraft from banking to the left after take off and elected to reduce power and land. The aircraft sustained substantial damage when the left wing tip struck the ground and cartwheeled during the…NTSB ANC85LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKAccording to a state police report, the plt assaulted his wife, then loaded his two children into the acft and flew to a refueling area. He refueled the acft, then tookoff & crashed aprx 1 mile north of the departure rwy. A witness reported that after the…