NTSB investigations, 1998, WI
3 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 5 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 2 |
| 2005 | 3 |
| 2007 | 2 |
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\") = 1998
AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
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\" = 130)
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."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA' 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" = 130) 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 CHI99LA016Accident · Minor injuriesLimited investigationFinal reportCessna 310I · Janesville, WIThe pilot's inadequate preflight inspection in which he failed to remove the tow bar from the nose gear. Also causal was his misjudgment of distance and altitude from the runway which resulted in both his premature shutdown of the engines and an undershoot of…NTSB CHI98LA213Accident · No injuriesLimited investigationFinal reportCessna 310N · Janesville, WIother maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.NTSB CHI98IA136Incident · No injuriesIncident investigationFinal reportRobinson R22 Beta · Franklin, WIThe mechanic's failure to follow the manufacturer's maintenance rebuilding instructions.