NTSB investigations: Lycoming 0-540 series, 2001
5 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 6 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 6 |
| 1995 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 4 |
| 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\") = 2001
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\" = 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") = 2001
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" = 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 ANC02LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Heiden, AKThe pilot's delay in aborting the landing. Factors in the accident were snow and ice on the runway surface, and the pilot's excessive taxi speed.NTSB ANC01LA131Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Koliganek, AKThe pilot's delay in aborting the takeoff. A factor in the accident was the pilot's diverted attention during the takeoff.NTSB CHI01LA281Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kenmare, NDThe pilot failed to maintain clearance with the terrain during the aerial application flight. Factors associated with the accident were the high vegetation and the pilot's diverted attention during the flight.NTSB MIA01LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain a visual lookout while maneuvering during a agricultural run, and inadvertent descent with a known sun glare resulting in an in-flight collision with terrain.NTSB ANC01TA035Accident · No injuriesFinal reportRobinson R-44 · Chickaloon, AKThe pilot's collision with terrain due to his inadequate planning of the approach, and his failure to maintain the helicopter's main rotor RPM during a go-around. Factors in the accident were a tailwind, flat lighting conditions, and snow-covered terrain.