NTSB investigations: Lycoming 0-540 series, 2003, FL
6 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 6 |
|---|---|
| 1965 | 11 |
| 1966 | 7 |
| 1967 | 9 |
| 1968 | 3 |
| 1969 | 1 |
| 1970 | 9 |
| 1971 | 2 |
| 1972 | 9 |
| 1973 | 9 |
| 1974 | 1 |
| 1975 | 5 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 6 |
| 1979 | 7 |
| 1980 | 12 |
| 1981 | 3 |
| 1982 | 6 |
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 3 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 3 |
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\") = 2003
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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'))
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") = 2003
AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
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'))
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 MIA03LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · West Palm Beach, FLThe poor judgment by the pilot-in-command of the airplane for his initiation of takeoff after the helicopter pilot had announced intention to perform a 180-degree autorotation to the runway, and the failure of both pilots to maintain visual lookout resulting…NTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB MIA03LA145Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Pierce, FLThe pilot's failure to maintain directional control of the airplane during landing roll resulting in collision with trees after the airplane departed the runway.NTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…NTSB MIA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Meade, FLThew failure of the pilot to abort the takeoff after travelling past the estimated point of liftoff, and failure of the pilot to maintain airspeed during the initial climb resulting in inadvertent stall and uncontrolled descent with subsequent impact onto the…NTSB MIA03CA091Accident · No injuriesData collectionFinal reportMaule M-5-235C · Jay, FLThe failure of the pilot to perform a go-around after bouncing following touchdown, resulting in the airplane nosing over during the landing roll.