Skip to content

NTSB investigations: Piper PA-28-150, CA

36 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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

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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  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

Run 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 WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.Sep 15, 2014 · N5948W · Substantial damage NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.Mar 26, 2006 · N5906W · Substantial damage 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.Jul 31, 2001 · N5346W · Substantial damage NTSB LAX99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Rubidoux, CAThe pilot's failure to maintain adequate clearance from parked airplanes while taxiing due to his diverted attention.Mar 13, 1999 · N5346W · Substantial damage NTSB LAX98LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Victorville, CAThe installation of incorrect washers for the brake manifold by maintenance personnel, which resulted in the left brake locking up, which made it impossible for the pilot to maintain directional control of the aircraft.May 30, 1998 · N5962W · Substantial damage NTSB LAX96LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Mecca, CAthe pilot/applicant's failure to maintain a glide path angle sufficient to maintain adequate clearance from all obstructions, and the examiner's inadequate supervision of the flight.Oct 28, 1995 · N5870W · Substantial damage NTSB LAX87LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · San Jose, CAThe acft went through a fence and collided with trees after a 'hand-propped' start. The student plt had exhausted the acft battery power during previous starting attempts. He then tied the acft down at both wings and the tail. He primed the eng with the…Nov 12, 1986 · N5153W · Substantial damage 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…Jul 16, 1983 · N5492W · Substantial damage NTSB LAX81FVM16Accident · No injuriesClosedPiper PA-28 · San Martin, CAMar 15, 1981 · N5282W · Substantial damage NTSB OAK77FXQ19Accident · Minor injuriesClosedPiper PA-28 · Donner Summit, CAMay 21, 1977 · N5561W · Destroyed NTSB OAK75DXQ23Accident · No injuriesClosedPiper PA-28 · Mammoth Lks, CASep 7, 1974 · N5968W · Substantial damage NTSB LAX74FVA16Accident · Serious injuriesClosedPiper PA-28 · Bakersfield, CAAug 9, 1973 · N5734W · Substantial damage NTSB LAX72DVA64Accident · No injuriesClosedPiper PA-28 · Bakersfield, CAMar 24, 1972 · N5208W · Substantial damage NTSB LAX72DUG49Accident · Minor injuriesClosedPiper PA-28 · Thermal, CAJan 10, 1972 · N5906W · Substantial damage NTSB IAD71FLJ17Accident · No injuriesClosedPiper PA-28 · Durham, CANov 15, 1970 · N5464W · Substantial damage NTSB OAK71FVG20Accident · No injuriesClosedPiper PA-28 · Chico, CASep 5, 1970 · N5708W · Substantial damage NTSB OAK71AP002Accident · No injuriesClosedCessna 172 · Fresno, CAJul 10, 1970 · N5790T · 2 aircraft · Substantial damage NTSB OAK70AP043Accident · 6 fatalClosedPiper PA-28 · Placerville, CAFeb 14, 1970 · N5942W · 2 aircraft · Destroyed NTSB LAX68D0320Accident · Serious injuriesClosedPiper PA-28 · Baker, CAJan 6, 1968 · N5765W · Substantial damage NTSB LAX68D0281Accident · Minor injuriesClosedPiper PA-28 · Lancaster, CADec 31, 1967 · N5952W · Substantial damage NTSB LAX68D0246Accident · No injuriesClosedPiper PA-28 · Carlsbad, CADec 17, 1967 · N5738W · Substantial damage NTSB LAX68A0006Accident · 2 fatalClosedPiper PA-28 · Sepulveda, CAJul 15, 1967 · N5966W · 2 aircraft · Destroyed NTSB LAX67D0391Accident · Minor injuriesClosedPiper PA-28 · Alta Loma, CAApr 15, 1967 · N5840W · Substantial damage NTSB LAX67D0253Accident · Minor injuriesClosedPiper PA-28 · Lucerne Val, CANov 12, 1966 · N5706W · Substantial damage NTSB OAK67F0150Accident · Serious injuriesClosedPiper PA-28 · Meyers, CAOct 1, 1966 · N5925W · Destroyed NTSB LAX66A0089Accident · No injuriesClosedPiper PA-28 · Santa Ynez, CAMay 18, 1966 · N5914W · 2 aircraft · Minor damage NTSB LAX66F0291Accident · Serious injuriesClosedPiper PA-28 · Chino, CAMar 2, 1966 · N5887W · Substantial damage NTSB LAX66F0175Accident · No injuriesClosedPiper PA-28 · Hawthorne, CADec 3, 1965 · N5757W · Substantial damage NTSB LAX66F0044Accident · Serious injuriesClosedPiper PA-28 · Corona, CAJun 12, 1965 · N5775W · Destroyed NTSB OAK65F0060Accident · No injuriesClosedPiper PA-28 · Turlock, CAMay 8, 1965 · N5848W · Substantial damage NTSB LAX65F0005Accident · No injuriesClosedPiper PA-28 · San Diego, CAFeb 13, 1965 · N5732W · Substantial damage NTSB OAK65D0005Accident · No injuriesClosedPiper PA28 · San Jose, CAJan 27, 1965 · N5700W · Substantial damage NTSB UNK65X1227Accident · No injuriesClosedPiper PA28 · Mt Pleasant, CAJan 3, 1965 · N5706W · Substantial damage NTSB UNK65X0602Accident · 2 fatalClosedPiper PA-28 · Springville, CANov 7, 1964 · N5756W · Destroyed NTSB UNK64X3197Accident · No injuriesClosedPiper PA28 · Van Nuys, CAAug 3, 1964 · N5734W · Substantial damage NTSB UNK64X2631Accident · No injuriesClosedPiper PA-28 · Fresno, CAJul 4, 1964 · N5346W · Substantial damage