NTSB investigations: Piper PA-28-150
5 cases on aircraft the registry lists as Piper PA-28-150, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2001 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102804')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102804')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 LAX01LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Hesperia, CAthe loss of engine power due to fuel exhaustion while maneuvering in an attempt to locate the runway. Contributing factors were the inadequate runway maintenance that resulted in inoperative runway edge lights, and the night light conditions.NTSB CHI94LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Little Falls, MNan improper preflight by the pilot-in-command and the pilot's failure to maintain airspeed during a turn. A factor associated with the accident was contaminated fuel.NTSB MIA92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Fayetteville, NCThe pilot-in-command's failure to perform an adequate preflight in that he failed to assure adequate fuel for the flight was available. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB LAX91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Sierra Vista, AZLoss of engine power due to carburetor ice from improper use of the carburetor heat control.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…