NTSB investigations: Piper PA-28-181, 1999
16 cases on aircraft the registry lists as Piper PA-28-181. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 16 |
| 1977 | 16 |
| 1978 | 29 |
| 1979 | 23 |
| 1980 | 28 |
| 1981 | 36 |
| 1982 | 21 |
| 1983 | 24 |
| 1984 | 10 |
| 1985 | 33 |
| 1986 | 26 |
| 1987 | 23 |
| 1988 | 21 |
| 1989 | 10 |
| 1990 | 20 |
| 1991 | 19 |
| 1992 | 9 |
| 1993 | 19 |
| 1994 | 20 |
| 1995 | 22 |
| 1996 | 12 |
| 1997 | 17 |
| 1998 | 20 |
| 1999 | 16 |
| 2000 | 10 |
| 2001 | 15 |
| 2002 | 10 |
| 2003 | 10 |
| 2004 | 20 |
| 2005 | 15 |
| 2006 | 9 |
| 2007 | 14 |
| 2008 | 8 |
| 2009 | 8 |
| 2010 | 11 |
| 2011 | 7 |
| 2012 | 8 |
| 2013 | 7 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 13 |
| 2019 | 8 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 19 |
| 2024 | 15 |
| 2025 | 13 |
| 2026 | 11 |
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\") = 1999
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
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 LAX00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palo Alto, CAThe failure of the pilot to properly calculate fuel consumption rate, and his improper in-flight planning to continue the flight to the destination airport instead of landing at a closer alternate airport. A factor was the pilot's inadequate aircraft control…NTSB LAX00LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hilo, HIAn oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.NTSB CHI99LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hermosa, SDthe pilot's improper fuel management, improper in-flight decision and the precautionary landing. Factors relating to this accident were the pilot's inadequate preflight planning and the fence post.NTSB DEN99FA157Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Villa Grove, COThe flight instructor's improper inflight decision to enter a narrow blind/box canyon, and his misjudgment of the vertical and lateral clearances. A factor was the downdrafts.NTSB LAX99LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Sacramento, CAFuel exhaustion due to the pilot's failure to ensure that sufficient fuel was on board to complete the flight, and, the flight instructor's inadequate supervision of the flight.NTSB DEN99LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tooele, UTAn inadequate flare during landing touchdown, resulting in a fracture of the right main landing gear strut. A factor was the flight instructor's failure to properly supervise the student.NTSB CHI99FA290Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Paw Paw, MIthe pilot flew into known adverse weather, the pilot's lack of total instrument flight experience, and the pilot exceeded the design limits of the airplane. Factors included the pilot's total lack of experience in the type of operation and the pilot's…NTSB MIA99LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greenville, SCThe improper position of the fuel selector by the pilot-in-command resulting in the loss of engine power due to fuel starvation. Also, the inadequate altitude flown by the pilot on final approach preventing a landing on the runway following the loss of engine…NTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.NTSB CHI99FA238Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Yorkville, ILthe pilot continuing into known adverse weather conditions, attempting low altitude flight, and not maintaining terrain clearance. Factors to the accident were the thunderstorm and the improper weather evaluation by the pilot following pre-departure and…NTSB LAX99LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Luis Obispo, CAA loss of engine power due to contamination of the induction system and the carburetor throat. Factors in the accident were a prior undetected carburetor fire, which caused a deterioration in the air duct material.NTSB MIA99LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Auburn, ALThe pilot' failure to refuel the airplane prior to fuel exhaustion.NTSB NYC99LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, OHA loss of engine power for undetermined reasons.NTSB LAX99LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Scottsdale, AZThe failure of the local and ground controller to coordinate the clearances of both aircraft and to maintain separation of the traffic in the taxiway movement area.NTSB ATL99FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Brevard, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB LAX99LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Arlington, AZThe flight instructor's inadequate supervision of his student and his failure to initiate timely remedial action. Contributing factors were the student's failure to maintain the proper glidepath under the existing downdraft condition, the flight instructor's…