NTSB investigations: Lycoming 0-540 series, 1983
7 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of control - on ground/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 | 7 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 6 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 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 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 ('41532')
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\" = 260))
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 ('41532')
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" = 260))
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 LAX84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · New River, AZThe tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.…NTSB FTW83LA307Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Franklinton, LAThe acft slid into a tree during a landing on a wet rwy. The plt had encountered the rain shortly after takeoff and returned to the arpt. The private strip had become soft from the rain and the plt lost control of the acft. The acft veered off the strip and…NTSB FTW83LA284Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Abilene, TXThe agricultural acft collided with a pole during an aborted takeoff after directional control was lost. The plt stated that a soft spot in the rwy caused the acft to veer left. The takeoff was aborted but the acft continued off the rwy andcollided with the…NTSB DEN83LA130Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cando, NDAfter returning to the arpt, the plt landed on rwy 30 with a right x-wind at about 16, gusting 23 KTS. Reportedly, the grass was aprx 1 ft tall on the rwy & the landing area sloped downward to the west. After touchdown, the plt maintained control of the acft…NTSB MKC83LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Kaiser, MOThe acft sustained substantial damage when the nose gear collapsed during landing. The weather was VMC but the pilot said he encountered a gusty crosswind during landing. He had checked the wind sock prior to landing and it was hanging limp. The reported wind…NTSB NYC83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Batavia, NYThe pilot had trouble with maintaining heading during the entire flight due to malfunction of the rudder trim. During landing, directional control was lost and the acft left the runway and collided with trees. An inspection of the rudder sys revealed…NTSB LAX83LA106Accident · No injuriesLimited investigationFinal reportCessna 182RG · Marble Canyon, AZDuring the landing the pilot lost control of the aircraft in a gusty wind. The aircraft left the runway and nosed over. In soft terrain. He blamed his slow reaction and inexperience for the accident. The wind was from 300 degrees at 11 KTS gusting to 18 KTS.