NTSB investigations: Costruzioni Aeronautiche Tecna P2002 SIERRA
14 cases on aircraft the registry lists as Costruzioni Aeronautiche Tecna P2002 SIERRA. 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
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 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 ('0600006'))
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 ('0600006'))
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 WPR21LA146Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Watsonville, CAThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.NTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.NTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.NTSB GAA16CA300Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Moundsville, WVThe pilot's failure to maintain directional control during the go-around in gusty crosswind conditions, which resulted in a collision with trees.NTSB ERA13CA423Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Ridgely, MDThe flight instructor's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.NTSB ERA11CA304Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Stevensville, MDThe student pilot's improper flare which resulted in a hard landing, and the flight instructor's lack of remedial action.NTSB WPR10LA202Accident · No injuriesLimited investigationFinal reportCostruzioni AeronauticheTecnam P2002 Sierra · Tooele, UTA total loss of engine power for undetermined reasons.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB ERA09CA300Accident · No injuriesData collectionFinal reportTecnam P2002 · Stevensville, MDThe pilot's failure to maintain proper airspeed on final approach, which resulted in an aerodynamic stall.NTSB ERA09CA262Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · Lake Wales, FLThe pilot’s failure to maintain aircraft control and failure to maintain clearance from trees during initial climb.NTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.NTSB DFW08CA107Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · La Porte, TXThe student pilot's improper recovery from the bounced landing and the instructor's delayed remedial action.NTSB MIA08LA034Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Stevensville, MDA loss of engine power due to the failure of company maintenance personnel to comply with engine manufacturers requirements for carburetor adjustment during the 100-hour inspection.