Final NTSB investigations: Lycoming IO-320-B1A
9 cases on aircraft whose registry engine model is Lycoming IO-320-B1A. 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
| 1974 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41907'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41907'))
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 CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.NTSB ERA16LA204Accident · Serious injuriesLimited investigationFinal reportBobbi Boucher DUO Deuce · Stafford, VAThe pilot's failure to attain adequate airspeed during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN14LA148Accident · 1 fatalLimited investigationFinal reportVans RV-9A · Tribune, KSThe pilot’s failure to maintain airplane control while conducting high-g turns, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to initiate the flight with a severe progressive neurological disorder that…NTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.NTSB CHI06CA129Accident · No injuriesData collectionFinal reportPiper PA-30 · Dongola, ILThe pilot's intentional maneuver to avoid obstructions at the end of the runway which resulted in the airplane impacting a ditch. The wet grass runway and the ditch were factors.NTSB CHI84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indianapolis, INAfter takeoff from dyersburg the gear would not fully retract. The plt attempted to lower the gear manually but it was stuck in the transient position. The plt then diverted to Indianapolis & landed with the gear in the transient position. Investigation…NTSB MIA79FA111Accident · 2 fatalClosedCessna 150 · W Palm Beach, FLNTSB MIA79FLD06Accident · No injuriesClosedPiper PA-30 · Ft Pierce, FLNTSB CHI74FEE66Accident · No injuriesClosedPiper PA-30 · Lansing, IL