NTSB investigations: Eiriavion PIK 20E
6 cases on aircraft the registry lists as Eiriavion PIK 20E. 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
| 1981 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1997 | 1 |
| 2000 | 2 |
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 ('5760207'))
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 ('5760207'))
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 SEA00LA144Accident · Serious injuriesLimited investigationFinal reportEiriavion PIK 20E · Hamilton, MTThe pilot's entering an inadvertent stall condition during a high angle of bank turn (maneuvering), and the lack of adequate altitude in which to successfully recover before ground impact.NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.NTSB NYC87LA009Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Erwinna, PAFlight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.NTSB ATL84LA174Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Thomasville, NCThe plt reported that the acft suffered a partial power loss at 150 ft AGL while on initial climb. The plt attempted to return to the airport to land and the eng lost total power. The pilot made a forced landing in a mature wheat field. Examination of the eng…NTSB DEN81FTE46Accident · Serious injuriesClosedEiriavion Oypik · Aspen, CO