NTSB investigations: Lycoming 0-320 series, 1983
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 24 |
|---|---|
| 1983 | 9 |
| 1984 | 11 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 15 |
| 1992 | 13 |
| 1993 | 11 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 9 |
| 1997 | 11 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 15 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 13 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 7 |
Where
Latest 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 ('41508')
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\" = 230))
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 ('41508')
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" = 230))
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 CHI84LA057Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Owosso, MIThe acft crashed shortly after takeoff from owasso airport. The plt stated that he noticed the takeoff roll was longer than normal but everything seemed alright until approximately 100 ft AGL when the acft would no longer climb. The acft impacted about 1/2…NTSB LAX84FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, CAThe acft collided with rising terrain at the 1600 ft level on a dark night. The plt was on a night cross-country and hadmade a radio call saying he was unsure of his position. He then reported his alt as 2000 ft. the buchanan tower gave him a heading to fly…NTSB ANC84LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Kodiak, AKAccording to the plt, the wind was gusting to 30 KTS or more and changing directions on the lake very rapidly. He further stated that 'you could see swirls of water on the lake's surface.' He departed the lake towards the east and when about 350 AGL…NTSB ANC83LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKReportedly, the plt was looking at an area in mountainous terrain near an off arpt landing area when he encountered windshear & a downdraft while turning. He stated that the alft dropped 400 ft & he applied full power; however, the left wing struck the ground…NTSB ANC83FA161Accident · 3 fatalField investigationFinal reportBellanca 7GCBC · Kasilof, AKThe acft crashed in a vertical nose down attitude a short distance from the plt's private airstrip. According to relatives the plt was taking his girl friend's 2 children for a short flt. Investigation revealed the plt's last known medical certificate was…NTSB MIA83LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocean Way, FLThe acft collided with the muddy bank of the intercoastal waterway during the 2nd of two low passes and nosed over when the nose gear dug in. Witnesses report seeing the acft pass at a low altitude. The pilot stated that while flying at lowalt he heard a loud…NTSB ANC83FA075Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Soldotna, AKWitnesses observed the acft maneuvering erratically near the arpt & anticipated the accident. The 1st approach to rwy 25WAS described as erratic with minimal apparent control which included an abrupt pull-up, stall, bounce, & go-around in aleft pattern at 300…NTSB FTW83LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Canton, TXThe plt reported that during arrival, he started to land with a right crosswind at 15 gusting 22 KTS. He stated that the acft was very low over the runway when a gust of wind blew it over a plowed area adjacent to the runway. He applied full power, raised the…NTSB DEN83LA061Accident · No injuriesLimited investigationFinal reportCessna 172K · Dove Creek, COThe acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…