NTSB investigations: Piper PA-28-150, 1983
4 cases on aircraft the registry lists as Piper PA-28-150. 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 | 10 |
|---|---|
| 1965 | 14 |
| 1966 | 19 |
| 1967 | 15 |
| 1968 | 11 |
| 1969 | 2 |
| 1970 | 8 |
| 1971 | 3 |
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 4 |
| 1976 | 1 |
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 4 |
| 1984 | 2 |
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102804'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102804'))
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 DEN83LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28B-150 · Watford City, NDThe acft nose gear collapsed during a precautionary landing due to weather. The plt had been briefed on the weather the evening before the accident. The pilot stated that when the flight was 20 minutes from home he 'thought we could make it.' However, he…NTSB MIA83FA197Accident · Serious injuriesField investigationFinal reportPiper PA-28-150 · Brandon, FLThe acft collided with trees and the ground after the engine lost power during takeoff. The CFI noted the RPM dropping to 2000 with full throttle and at about 75 AGL and tried to arrest the descent with flaps but was unsuccessful. One takeoff had been aborted…NTSB LAX83LA344Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Columbia, CAThe acft contacted a powerline 100 ft above the water at new mellones reservoir. The acft was landed at Columbia. CA without further incident. An inspection of the acft revealed that the top portion of the vertical stabilizer was missingand the rudder was…NTSB CHI83LA296Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Kelleys Island, OHThe acft lost power on takeoff and collided with trees about 1/4 mile off the end of the rwy. The pilot said he prefltedand removed about 1/2 ounce of water from each tank, none from the gascolator. Inspection after the accident revealed water in the…