NTSB investigations: Ica Brasov IS-29D2
5 cases on aircraft the registry lists as Ica Brasov IS-29D2. 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
| 1980 | 1 |
|---|---|
| 1983 | 2 |
| 1999 | 1 |
| 2011 | 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 ('4490106'))
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 ('4490106'))
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 ERA12CA027Accident · No injuriesData collectionFinal reportIca Brasov IS-29D2 · Benton, TNThe pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.NTSB LAX99LA192Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D2 · Tehachapi, CAThe pilot's inability to maintain a proper glide path due to an inadvertent encounter with an area of high sink rate conditions. The mountainous/hilly nature of the terrain which limited the pilot's selection of a landing site is a factor.NTSB FTW83LA314Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-2902 · Katy, TXThe glider collided with a ditch during a forced landing after the tow rope disconnected shortly after takeoff. The plt was not able to avoid the ditch during landing due to a strong sink rate. The tow hook assembly was examined after the accident and no…NTSB LAX83LA273Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D2 · Reno, NVAccording to the plt, he received an aerial tow to 2500 ft AGL, and after releasing, the glider encountered sinking wx conditions. He proceeded back to the arpt. After entering a downwind for landing, the glider reportedly encountered an area of extreme sink.…NTSB NYC80DFA20Accident · No injuriesClosedLark IS29D2 · Marbleton, NY