Final NTSB investigations: Continental IOF-240-B
6 cases on aircraft whose registry engine model is Continental IOF-240-B. 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
| 2006 | 1 |
|---|---|
| 2007 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2022 | 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 ('17168'))
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 ('17168'))
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 WPR22LA116Accident · No injuriesClass 4 · LimitedFinal reportLiberty Aerospace Liberty XL-2 · Las Cruces, NMThe airplane’s inability to climb during takeoff due to a degradation of engine performance due to high density altitude. Contributing to the accident was the pilot’s decision to continue the takeoff.NTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.NTSB ERA16LA113Accident · No injuriesLimited investigationFinal reportLiberty Aerospace Liberty XL · Orlando, FLA failure of the right brake for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's decision to continue the flight after experiencing a braking anomaly due to his perceived need for an…NTSB NYC07FA196Accident · Serious injuriesField investigationFinal reportLiberty Aerospace XL2 · Ormond Beach, FLThe student pilot's failure to maintain aircraft control during an attempted go-around.NTSB MIA07IA052Incident · No injuriesIncident investigationFinal reportLiberty Aerospace XL-2 · Ormond Beach, FLThe improper manufacturing of the nose undercarriage leg by the vendor, and the inadequate surveillance of the vendor by the airplane manufacturer.NTSB DEN07CA026Accident · Serious injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Albuquerque, NMthe student pilot's improper flare and subsequent improper recovery from a bounced landing resulting in an inadvertent loss of control.