NTSB investigations: I.C.A.-Brasov IS-28B2, TX
5 cases on aircraft the registry lists as I.C.A.-Brasov IS-28B2. 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
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 2012 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4490102'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4490102'))
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 CEN12FA378Accident · 4 fatalField investigationFinal reportIar Brasov IS-28B2 · Wallis, TXThe pilot’s failure to maintain adequate airspeed during an emergency situation, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s acute coronary event, which resulted from his severe…NTSB FTW89DQA02Accident · Serious injuriesFinal reportI.C.A. Brasov IS-28B2 · El Paso, TXThe failure of the pilot to maintain adequate airspeed, while maneuvering to land in turbulent weather, which resulted in a stall/spin and subsequent collision with a tree and the ground. Turbulence was a factor.NTSB FTW85LA266Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Georgetown, TXThe accident occurred during an glider launch. The tow acft was unable to gain alt, and turned back to the arpt to release the glider. The tow acft began to sink into the trees and was forced to release the glider beyond safe gliding distance to the rwy. The…NTSB FTW82DA368Accident · No injuriesFinal reportBellanca 8GCBC · Katy, TXN1052Y an I.c.a brasov glider was being towed for takeoff. During the takeoff run the towplane aborted and continued to roll straight ahead on the center line of a relatively narrow turf airstrip. The pilot of N1052K deployed his spoilers and attempted to…NTSB FTW82DA219Accident · No injuriesFinal reportI.C.A. Brasov - Romania IS-28B2 · El Paso, TXThe sailplane was towed to about 200 ft AGL when the tow rope separated. When the pilot realized he was unable to return to the airport he attempted a landing along a river levee. The left wing struck the levee and the aircraft cartwheeled.