NTSB investigations: Lycoming 0-540 series, 1999, FL
7 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
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\") = 1999
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") = 1999
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 MIA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, FLThe pilot's failure to complete the before landing checklist and extend the landing gear, resulting in a gear up landing. A factor in the accident is the failure of the landing gear warning circuit to activate the cockpit warning horn.NTSB MIA00LA011Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Ft. Lauderdale, FLThe PIC's improper use of cyclic control during landing which resulted in a main rotor strike of the terrain and the rotorcraft's tail boom.NTSB MIA99LA274Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · St. Augustine, FLThe inadvertent inflight collision with a bird resulting in substantial damage to the right wing outboard leading edge.NTSB MIA99LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · St. Petersburg, FLthe pilots improper use of the hand brake during the landing roll out and his failure to maintain directional control, which resulted in the airplane exiting the runway and incurring substantial damage.NTSB MIA99LA116Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235B · Boca Grande, FLThe pilots failure to maintain a visual lookout on landing resulting in an in-flight collision with a wave.NTSB MIA99LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Everglades City, FLThe failure of the PIC to maintain directional control on takeoff roll following a loss of power brought about by fuel starvation due to the PIC's failure to verify the proper setting of the fuel selector valve, and the subsequent collision with trees during…NTSB MIA99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Orlando, FLA loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.