NTSB investigations: Lycoming O-320-A2B
71 cases on aircraft whose registry engine model is Lycoming O-320-A2B. 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, newest first
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'))
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'))
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 ANC83LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, AKThe pilot stated that he felt the engine did not develop full power during takeoff, possibly due to formation of carburetor ice during rain showers. Instead of aborting, he continued and the acft struck trees on the departure.NTSB NYC82DA086Accident · No injuriesFinal reportChampion 7GCAA · New London, NHAfter towing a glider, the pilot returned to an unimproved airstrip and landed. During the landing roll, the aircraft became mired in soft sand and nosed over.NTSB DEN80FTC17Accident · No injuriesClosedPiper PA-18 · Cheyenne, WYNTSB ANC78DAG62Accident · No injuriesClosedBellanca 7ECA · Palmer, AKNTSB MKC76FCJ61Accident · No injuriesClosedPiper PA-25 · Holdrege, NENTSB FTW76DRJ29Accident · No injuriesClosedPiper PA-18 · Oak Grove, LANTSB MKC72FER30Accident · Serious injuriesClosedPiper PA-18 · Gilman, MNNTSB MIA70D0294Accident · No injuriesClosedPiper PA-18 · Rebecca, GANTSB ANC70D0040Accident · No injuriesClosedPiper PA-18 · Takotna, AKNTSB SEA69F0022Accident · Minor injuriesClosedPiper PA-18 · Lowell, ORNTSB SEA68D0221Accident · No injuriesClosedPiper PA-18 · Preston, IDNTSB MKC68D0276Accident · No injuriesClosedPiper PA-12 · Pipestone, MNNTSB DEN68F0005Accident · No injuriesClosedPiper PA-18 · Montrose, CONTSB ANC67D0012Accident · No injuriesClosedPiper PA-18 · Paxton, AKNTSB MKC66D0183Accident · No injuriesClosedPiper PA-12 · Pipestone, MNNTSB ANC65F0011Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKNTSB MKC65D0036Accident · No injuriesClosedPiper PA-20 · Dawson, IANTSB UNK64X2936Accident · 2 fatalClosedPiper PA18 · Orovada, NVNTSB UNK64X2353Accident · Minor injuriesClosedPiper PA22 · New Alexander, PANTSB UNK64X0927Accident · No injuriesClosedPiper PA22 · Tampa, IANTSB UNK64X0200Accident · No injuriesClosedPiper PA22 · St Paul, MN