NTSB investigations: I.C.A.-Brasov IS-29D
4 cases on aircraft the registry lists as I.C.A.-Brasov IS-29D. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 2018 | 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 ('4490104'))
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 ('4490104'))
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 WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB LAX90LA104Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov 2902.11.01.001 Lark · Orland, CAThe pilots loss of aircraft control due to the likelihood of experiencing an epileptic seizure. A factor which may have contributed to the accident was the pilot's ingestion of an anticonvulsant drug that causes drowsiness.NTSB SEA88LA118Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov IS-29D · Athol, IDPlt was on third flt in make/model. Witness stated approach was too low and slow to make airport. Acft made a turn to the left and then to the right. Wing dropped and acft entered stall/spin to the right and continued rotation to the ground.NTSB SEA83LA109Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D · Ephrata, WAThe plt reported that he was forced to land after thermal activity subsided and he was unable to find an area of lift. He elected to land in the last cultivated field before reaching an area of sage brush. Reportedly, a dust devil was encountered during…