NTSB investigations: Piper PA-28-181, 1998
20 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\") = 1998
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") = 1998
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 DEN99LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rollinsville, COThe pilot's inadequate decision to continue flight into deteriorating weather conditions, that included a downdraft which resulted in a loss of control, and collision with terrain. Contributing factors were the pilot's lack of familiarity with the terrain,…NTSB MIA99LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Haines City, FLThe pilot's failure to recognize the onset of carburetor icing and take corrective action prior to engine failure and the pilot's failure to maintain visual outlook while making a forced landing resulting in the aircraft colliding with trees.NTSB LAX99FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Santa Clarita, CAthe pilot's failure to maintain control of the aircraft. Factors were the night weather conditions and the lack of total and recent instrument flight time.NTSB CHI99LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mason, MIthe pilot's inattention to fuel management in that he failed to switch fuel tanks in a timely manner which resulted in fuel starvation. A factor related to the accident was the low altitude at which the loss of engine power occurred.NTSB DEN99LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Tooele, UTThe pilot's VFR flight into IMC and his failure to maintain adequate terrain clearance. Contributng factors were fog, low ceilings, high terrain, the pilot's lack of familiarity with the geographic environment and his misinterpretation of terrain features on…NTSB LAX99LA011Accident · 3 fatalLimited investigationFinal reportPiper PA-28-181 · Shelter Cove, CAThe pilot's excessive airspeed, failure to attain the proper touchdown point, and the delayed decision to initiate a go-around.NTSB DEN99FA009Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Montrose, COThe pilot's improper inflight planning/decision. Factors were a reduction in the airplane's climb and turn capabilities, the aft c.g. limit being exceeded, and the pilot's lack of familiarity with the geographic area and his lack of experience in the airplane…NTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.NTSB LAX98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oroville, CAthe pilot's inaccurate preflight and in-flight fuel consumption calculations, which resulted in fuel exhaustion. The pilot's failure to obtain the proper engine power setting charts to use in fuel consumption calculations was also causal.NTSB ATL98FAMS1Accident · 4 fatalMissing aircraftFinal reportPiper PA-28-181 · MissingThe aircraft is missing.NTSB CHI98LA324Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Michigan City, INthe pilot departed into known adverse weather and failed to maintain directional control of the airplane. A factor was the fog.NTSB FTW98LA359Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grand Prairie, TXFuel exhaustion due to the pilot's failure to refuel which resulted in the loss of engine power. Factors were the lack of suitable terrain for the forced landing, and the dark night light conditions.NTSB NYC98LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · West Liberty, KYThe pilot's inadequate planning for a downslope landing. A factor was the pilot's lack of training for downslope landing situations.NTSB FTW98LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fairview, OKLoss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springfield, MOthe pilot in command's inadequate preflight planning/preparation and inaccurate fuel consumption calculations that caused the aircraft's fuel supply to be exceeded. Factors to the accident were the dark light condition and the rough/uneven terrain condition.NTSB LAX98FA188Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Bangor, CAThe pilot's attempted flight into instrument meteorological conditions, loss of spatial orientation, and the resultant loss of airplane control. Contributing factors were his improper preflight and in-flight decisions, overconfidence in his personal ability,…NTSB LAX98LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · El Cajon, CAThe certified flight instructor's inadequate preflight which led to fuel exhaustion and subsequent loss of engine power. A related factor was the unsuitable terrain.NTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…NTSB NYC98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAfailure of the pilot to maintain directional control of the airplane during the takeoff roll; and/or his failure to abort the takeoff, while there was sufficient space available to do so without hitting trees.NTSB MIA98LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Charlotte, NCthe pilot's failure to follow proper starting procedures.