Skip to content

NTSB investigations: Piper PA-22-150, NV

18 cases on aircraft the registry lists as Piper PA-22-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" = 'NV' 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 ('7102210')) 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\" = 'NV' 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 ('7102210'))
  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" = 'NV' 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 ('7102210'))
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 WPR11CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Pahrump, NVThe pilot's inadvertent activation of brakes upon touchdown, resulting in a loss of directional control.Oct 27, 2010 · N7807D · Substantial damage NTSB LAX05CA268Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Reno, NVThe pilot's inadequate compensation for the crosswind gust and failure to maintain lateral and directional control during the landing flare.Aug 14, 2005 · N6045D · Substantial damage NTSB LAX04CA189Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Minden, NVthe pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control of the airplane, resulting in a collision with terrain.Apr 18, 2004 · N6062D · Substantial damage NTSB LAX00LA351Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty and variable crosswind conditions. Factors were the variable and gusty crosswinds.Sep 23, 2000 · N2963P · Substantial damage NTSB LAX93LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Reno, NVThe pilot's poorly planned approach, inadequate compensation for the existing winds, and failure to maintain airspeed. Contributing to this accident was the pilot's lack of total expereince and inadvertent stall.Nov 1, 1992 · N3722Z · Substantial damage NTSB LAX91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA22-150 · Las Vegas, NVThat the pilot improperly selected the fuel tank that did not contain any fuel and his subsequent failure to maintain airspeed.Apr 15, 1991 · N4416A · Substantial damage NTSB SEA88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Hawthorne, NVDuring a go-around due to the pilot having difficulty landing with a gusting crosswind, the aircraft struck a barbed wire fence with the main landing gear and a fence post with the left horizontal stabilizer. The aircraft then crossed a road and came to rest…Jun 3, 1988 · N3741P · Substantial damage NTSB LAX81DXQ35Accident · Serious injuriesClosedPiper PA-22 · Jackpot, NVSep 4, 1981 · N7308D · Destroyed NTSB LAX80FXQ32Accident · No injuriesClosedPiper PA-22 · Carson City, NVJul 27, 1980 · N5911D · Substantial damage NTSB OAK78DXQ47Accident · No injuriesClosedPiper PA-22 · Elko, NVSep 15, 1978 · N3615Z · Substantial damage NTSB OAK76AP040Accident · 2 fatalClosedPiper PA-22 · Searchlight, NVJan 23, 1976 · N2614P · Destroyed NTSB OAK7LAP009Accident · 4 fatalClosedPiper PA-22 · Hawthorne, NVSep 6, 1975 · N6178D · Destroyed NTSB OAK67A0068Accident · 1 fatalClosedPiper PA-22 · Sutcliffe, NVMar 12, 1967 · N1743P · Destroyed NTSB LAX66D0004Accident · Minor injuriesClosedPiper PA-22 · Las Vegas, NVMar 30, 1965 · N3348Z · Substantial damage NTSB UNK65X0681Accident · 1 fatalClosedPiper PA22 · Battle Mt., NVNov 12, 1964 · N3149Z · Destroyed NTSB UNK65X0413Accident · 2 fatalClosedPiper PA-22 · Reno, NVOct 24, 1964 · N2427P · Destroyed NTSB UNK64X4103Accident · No injuriesClosedPiper PA22 · Reno, NVSep 22, 1964 · N9830D · Substantial damage NTSB UNK64X4061Accident · No injuriesClosedPiper PA22 · Sparks, NVSep 20, 1964 · N7144D · Substantial damage