NTSB investigations: Lycoming 0-145B series, 1983
4 cases on aircraft whose registry engine model is Lycoming 0-145B series. 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
| 1964 | 10 |
|---|---|
| 1965 | 8 |
| 1966 | 5 |
| 1967 | 13 |
| 1968 | 10 |
| 1969 | 3 |
| 1970 | 7 |
| 1971 | 4 |
| 1972 | 6 |
| 1973 | 6 |
| 1974 | 5 |
| 1975 | 6 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 8 |
| 1979 | 4 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 3 |
| 1990 | 3 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 3 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2018 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41502'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41502'))
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 FTW84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Bulverde, TXThe acft collided with a ditch during landing rollout after loss of control and a groundloop. According to the plt the landing was normal on a 2850 ft strip. The acft groundlooped at slow speed and went into a ditch off the right side of rwy 16. This flt was…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…NTSB ATL83LA233Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Toddville, MDThe acft made an emergency landing while skidding after the aileron control jammed. The pilot in the rear seat and the owner in the front seat said that after a couple of steep turns the aileron control could not be moved. The acft was in a left wing down…NTSB NYC83LA139Accident · Minor injuriesLimited investigationFinal reportAeronca 65-LB · Auburn, NYAccording to the plt, he was en route when the eng lost power. He maneuvered for a forced landing in a nearby hay/corn field. During the flare, the eng regained power momentarily & lifted about 50 ft. at about the same time, the acft encountered wind gusts,…