NTSB investigations, 1988
8 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 5 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 7 |
| 1990 | 2 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 4 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2006 | 1 |
Where
Latest 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\") = 1988
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\" = 110)
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") = 1988 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" = 110) 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 NYC89FA032Accident · 1 fatalField investigationFinal reportMooney M20K · Holden, MAInflight loss of control due to spatial disorientation and contact with trees prior to regaining control after the pilot experienced an unknown problem with the autopilot. Contributing was the lack of recent night experience.NTSB NYC88IA246Incident · Minor injuriesIncident investigationFinal reportBoeing 747-100 · Georgetown, GuyanaIncident that led to the death of the passenger in row #6 was apparently not related to turbulence, because the passenger died of choking two hours after the turbulence encounter.NTSB DEN88FA202Accident · 1 fatalField investigationFinal reportBeech 200 · Jackson, WYThe plt and his two pax had just arrived at the Jackson hole airport (jax) approximately 30 minutes prior to the accident. The plt dropped off his pax and stepped into operations for a short break. He then returned to the acft by himself for a return flt to…NTSB DEN88GA185Accident · 1 fatalFinal reportCessna 182R · Georgetown, CONTSB CHI88DER10Accident · No injuriesFinal reportAnderson-Tucker Evans VP-1 · Duquette, MNOn the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees.NTSB CHI88FA091Accident · No injuriesField investigationFinal reportBeech B90 · St. Paul, MNMechanical failure and sticking of the pilots thumb operated trim switch causing nose down pitch command. The failure of the cabin heater and the low cabin temperature are contributing factors.NTSB NYC88IA067Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-35 · Teterboro, NJThe MU-2 made a departure and while climbing through approximately 800 ft AGL, there was an inadvertent auto-pilot engagement. The nose pitched down and right. Both pilots got on the controls and control was maintained. A normal landing was made at the point…NTSB CHI88FA048Accident · Serious injuriesField investigationFinal reportBoeing 767-200 · Chicago, ILA flight attendant and a passenger received serious and minor injuries respectively during an inflight encounter with severe turbulence during an enroute descent. Greater than moderate turbulence was forecast to be in the area and severe turbulence had been…