NTSB investigations, 1998
4 cases where the first occurrence was “Gear retraction on ground”.
Cases per year
| 1994 | 1 |
|---|---|
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 3 |
| 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\") = 1998
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\" = 198)
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") = 1998 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" = 198) 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 MIA99LA010Accident · No injuriesLimited investigationFinal reportBeech C-90 · Meridian, MSThe pilot's inadvertent activation of the landing gear control handle during an attempted go-around, resulting in the retraction of the landing gear and subsequent on ground collision with terrain.NTSB FTW98LA389Accident · No injuriesLimited investigationFinal reportCessna 401 · Lancaster, TXThe pilot's inadvertent retraction of the landing gear while intending to retract the flaps. A factor was the pilots lack of total experience in the type of aircraft.NTSB MIA98LA225Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe student's improper retraction of the landing gear and the instructor's inadequate supervision.NTSB FTW98LA375Accident · No injuriesLimited investigationFinal reportBeech D95A · Albuquerque, NMThe pilot's inadvertent raising of the landing gear during landing rollout