NTSB investigations: Lycoming 0-145B series
9 cases on aircraft whose registry engine model is Lycoming 0-145B series, 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1991 | 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 ('41502')
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 ('41502')
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 NYC07CA113Accident · No injuriesData collectionFinal reportMooney M-18L · Bessemer, ALThe pilot's failure to maintain control which resulted in a hard landing and subsequent gear collapse during the landing roll. A factor in the accident was wind gusts.NTSB CHI94LA210Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Peshtigo, WIthe pilot's failure to maintain airspeed during the takeoff which resulted in an inadvertent stall. A factor related to the accident was the tall grass on the airstrip.NTSB LAX91LA259Accident · Minor injuriesLimited investigationFinal reportPiper J3L · Shasta Lake, CAThe pilot-in-command's failure to maintain airspeed on initial takeoff climb resulting in an in flight loss of control, stall, and inflight collision with terrain/water.NTSB MIA87LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Deland, FLThe plt stated that just after take-off, the rt wing was lifted by a x-wind & the acft stalled & crashed into the trees. The plt stated that the accident could have been prevented if he had decreased the angle of attack after take-off & had made 'a turn into…NTSB NYC87LA157Accident · No injuriesLimited investigationFinal reportPiper J-3 · Mercer, PAThe flight departed from runway 27 uphill with the wind at 180 degrees in uncut grass. There were trees on the left side of the departure end of the runway. The plt stated that he lost lift as he approached the departure end of the runway.NTSB MKC86FA103Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Independence, MOThe pilot stated that they took off to the north with an intended southwest bound departure. After a left turn, while on the crosswind leg, and climbing through 800 feet, a blast of cold air and wind shear hit the aircraft, and the bottom fell out, according…NTSB CHI86FA120Accident · 2 fatalField investigationFinal reportLuscombe 8B · Pittsford, MIThe pilot overshot final approach due to a 10-15 kt tailwind on base leg. According to a pilot friend on the ground he put the acft into a 60 degree bank to in an attempt to realign himself with the final approach course. During this steep turn the aircraft…NTSB MIA85FA251Accident · 1 fatalField investigationFinal reportJodel D-9 · Okeechobee, FLThe plt had flown only 4 has in the last 6 months in a Cessna 150 type acft & had never flown a Jodel 09 before. The plt boarded the acft, declined a cockpit check by the owner & made an immediate take off. The plt took off from the grass strip without…NTSB ATL83LA254Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BL-65 · Angier, NCThe acft collided with the ground in a nose low attitude just off the end of the rwy after a touch and go landing. Ground witnesses saw the acft make a touch and go landing, pull up, and saw a wing drop as the acft nosed down to the ground. The plt-owner was…