NTSB investigations: Costruzioni Aeronautiche Tecna P92 EAGLET
12 cases on aircraft the registry lists as Costruzioni Aeronautiche Tecna P92 EAGLET. 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
| 2013 | 1 |
|---|---|
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2026 | 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 ('0600045'))
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 ('0600045'))
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 GAA26WA180Incident · Minor injuriesClass 5 · ForeignCostruzioni Aeronautiche Tecna P92 Eaglet · Dajabon, Dominican RepublicNTSB ERA23LA149Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 · Church Hill, MDThe student pilot’s failure to maintain airplane control during the landing attempt and the flight instructor’s inadequate remedial action.NTSB ERA22LA093Accident · No injuriesClass 4 · LimitedFinal reportTecnam P92 · Apopka, FLThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a runway excursion and impact with a hangar.NTSB ERA21LA394Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Apopka, FLA loss of directional control during landing for reasons that could not be determined based upon the disposition of the wreckage following a late accident report.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.NTSB GAA18CA228Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Ashland, VAThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB GAA16CA094Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Chesapeake, VAThe pilot's loss of directional control during takeoff which resulted in impact with the ground.NTSB GAA15CA014Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MDThe pilot's failure to maintain directional control during takeoff.NTSB ERA14CA258Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe student pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB WPR14CA033Accident · No injuriesData collectionFinal reportTecnam P92 · Watsonville, CAThe pilot's failure to maintain directional control during landing.