NTSB investigations: Sukhoi SU-29
9 cases on aircraft the registry lists as Sukhoi SU-29. 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
| 1993 | 1 |
|---|---|
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2007 | 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 ('9850103'))
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 ('9850103'))
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 SEA07LA081Accident · No injuriesLimited investigationFinal reportCessna T210N · Livermore, CAThe pilot's failure to maintain clearance from another aircraft holding on the taxiway while taxiing from landing. The pilot's inadequate visual lookout was a factor.NTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…NTSB DEN01LA026Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Longmont, COThe inadequate structural materials (American manufactured verses original Russian materials) used during a major repair.NTSB MIA99LA242Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fort Lauderdale, FLan in-flight failure of the right aileron due to fatigue cracking in the attachment structure of the right inboard aerodynamic compensator, which resulted in a loss of control, a forced landing, and subsequent impact with the ground.NTSB IAD98FA061Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Manassas, VAThe pilot's failure to maintain adequate altitude/clearance during an aerobatic maneuver.NTSB NYC98LA010Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Williamstown, NJThe pilot misjudged his altitude and airspeed.NTSB FTW96FA208Accident · 1 fatalField investigationFinal reportJerrell RV-4 · Englewood, COfailure of the pilot of the RV-4, N44AZ, to comply with an ATC clearance by landing on the wrong runway, and the failure of the pilot of the SU-29, N55SU, to maintain an adequate visual lookout. Factors in the accident were: the failure of the air traffic…NTSB FTW96FA151Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · New Orleans, LAThe in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.NTSB DEN93LA058Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fountain, COFailure of both the pilot in command and the safety pilot to relinquish control of the airplane. A factor was the pilot in command's failure to communicate with the safety pilot.