NTSB investigations, 1983
4 cases where the first occurrence was “Other gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 195)
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 year(c."eventDate") = 1983 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 195) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 FTW84IA094Incident · No injuriesIncident investigationFinal reportSikorsky S76A · Cameron, LAThe helicopter was on initial climb when the #1 engine failed explosivly. A post explosion fire ensued and both fire bottles were utilized to no avail. During landing the gear collapsed and the acft settled on its belly. The cause of the engine failure is…NTSB LAX83LA403Accident · No injuriesLimited investigationFinal reportBell 206-B3 · Avenal, CAThe plt was demonstrating autorotative landings in a helicopter equipped with high skid landing gear. During his 4th autorotation, he made a straight-in apch & touched down on level, smooth terrain. As the helicopter was stopping, the high skid rotated…NTSB CHI83IA162Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71 · Minneapolis, MNWhile in curise flight a tire on theleft main landing gear blew out. On landing roll a fire erupted in the area of the left main landing gear, which was extinguished by airport crash rescue personal.NTSB DEN83IA083Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Denver, CODuring takeoff the inboard left main landing gear tire & wheel departed the acft. The flight returned and landed withoutfurther incident. Examination of the wheel rim revealed multiple fatigue cracks in the rim.