NTSB investigations, 1994
15 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 35 |
|---|---|
| 1983 | 18 |
| 1984 | 43 |
| 1985 | 44 |
| 1986 | 51 |
| 1987 | 43 |
| 1988 | 43 |
| 1989 | 45 |
| 1990 | 28 |
| 1991 | 45 |
| 1992 | 28 |
| 1993 | 22 |
| 1994 | 15 |
| 1995 | 28 |
| 1996 | 36 |
| 1997 | 44 |
| 1998 | 25 |
| 1999 | 32 |
| 2000 | 41 |
| 2001 | 40 |
| 2002 | 24 |
| 2003 | 37 |
| 2004 | 34 |
| 2005 | 33 |
| 2006 | 34 |
| 2007 | 34 |
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\") = 1994
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\" = 430)
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") = 1994 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" = 430) 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 CHI95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadequate design of the reserve parachute cable housing, which resulted in an inadvertent deployment of the parachute, and subsequent collision with, and jamming of, the aircraft's horizontal stabilizer, necessitating a forced landing.NTSB FTW95LA088Accident · No injuriesLimited investigationFinal reportBeech 1900D · Farmington, NMGround personnel failed to properly secure the cargo door.NTSB MIA95LA032Accident · 1 fatalLimited investigationFinal reportCessna 172D · Miami, FLThe passenger committed suicide.NTSB FTW94FA279Accident · No injuriesField investigationFinal reportDassault DA 200 · New Orleans, LAThe captain's decision to abort the takeoff after accelerating past V1. A factor was the fluctuating engine instrument for undetermined reasons.NTSB LAX94LA333Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Phoenix, AZthe failure of the headset operator to adhere to established company safety procedures when he diverted his attention during pushback. A factor in the accident was the airline's failure to modify its ground handling procedures and equipment to eliminate the…NTSB MIA94LA195Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Merritt Island, FLFailure of the pilot to visually verify that the tow rope was not wrapped around any flight control surface and the inadvertent stall/spin. Contributing to the accident was the entanglement of the tow equipment with the rudder horn, rudder movement was…NTSB NYC94LA117Accident · Serious injuriesLimited investigationFinal reportWSK PZL Wilga 80 · Churchville, MDImproper starting procedure by the pilot.NTSB NYC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ellisburg, NYA fuel or fuel system problem that was probably related to the pilot/owner's failure to assure proper maintenance and/or inspection of the airplane before flight. A factor related to the accident was: soft terrain in the emergency landing area.NTSB CHI94LA227Accident · No injuriesLimited investigationFinal reportCessna 441 · Flint, MIAn inadequate preflight inspection of the airplane by the pilot. Factors associated with this accident were unlatched nose cargo doors and the pilot's failure to extend the landing gear.NTSB ATL94LA098Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Burlington, NCInadvertent burner control interference by the passenger. A factor was the presence of electric transmission wires at the forced landing site.NTSB MIA94LA118Accident · No injuriesLimited investigationFinal reportCessna 310J · Ocala, FLFailure of the pilot to assure the generators were engaged before flight (failed to follow the checklist).NTSB NYC94LA062Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-61 · Covington, KYThe captain's improper decision to conduct flight at high altitude in an unpressurized airplane, which resulted in his incapacition from depressurization sickness. A factor related to the accident was: maintenance personnel failed to properly secure the…NTSB ANC94IA037Incident · No injuriesIncident investigationFinal reportBoeing 747-200F · Anchorage, AKThe attempt, by the pilot in command, to attempt takeoff with the parking brake controll engaged, resulting from incorrect procedures by the pilot in command.NTSB CHI94IA095Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace ATP · Mosinee, WIthe inadequate design of the PBSI electrical switch(es), and the operator's failure to expeditiously implement corrective Service Bulletins.NTSB MIA94IA043Incident · No injuriesIncident investigationFinal reportBoeing 767-322 · Miami, FLEmergency procedure initiated by an unqualified person.