NTSB investigations: Rockwell International 112A
5 cases on aircraft the registry lists as Rockwell International 112A, where the first occurrence was “Loss of engine power”. 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1994 | 2 |
| 1995 | 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 ('7630302')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 ('7630302')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 MIA96LA010Accident · No injuriesLimited investigationFinal reportRockwell 112A · Meridianville, ALLoss of engine power due to inadequate maintenance during the 100-hour annual. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB FTW94LA269Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Eagle Lake, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA162Accident · No injuriesLimited investigationFinal reportRockwell 112A · Henderson, NVThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW86FA075Accident · Serious injuriesField investigationFinal reportRockwell 112A · El Paso, TXThe plt rprtd that the eng quit immediately after takeoff. During an emerg landing on arpt property, the acft collided with a sand dune & nosed over. An exam of the eng revealed no discrepancies. The extent of damage prevented a thorough exam of the fuel sys.…NTSB NYC85LA077Accident · No injuriesLimited investigationFinal reportRockwell 112A · Waynesburg, PAThe acft was landed gear-up in a fld following a loss of pwr during an initial takeoff climb. Purpose of the flt was to check the eng as it had been disassembled because of metal contamination from the center main bearing. Post accident inspection of the eng…