NTSB investigations, 2002
24 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\") = 2002
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") = 2002 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 CHI03LA031Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNThe cabin flight crew not verifying the galley service cart had been properly stowed prior to departure, which resulted in the inadvertent deployment of the galley service cart during initial climb after takeoff.NTSB FTW03LA041Accident · 1 fatalLimited investigationFinal reportCessna 152 · Houston, TXThe dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.NTSB NYC03LA016Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Flushing, NYAn inadvertent trauma to the passenger's foot during an emergency evacuation.NTSB NYC03LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Block Island, RIThe pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.NTSB CHI02LA298Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Little Falls, MNThe inadequate starting procedure by the pilot.NTSB LAX02LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Weed, CAThe pilot's failure to follow adequate hand propping engine starting procedures.NTSB FTW02LA255Accident · No injuriesLimited investigationFinal reportCessna 182P · Kirbyville, TXThe pilot's physical impairment due to a previous head injury which resulted in his becoming disoriented. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB ANC02LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Akiak, AKThe unsuitable and soft terrain in the area of a precautionary landing, which resulted in a nose over. Contributing factors in the accident were a false indication of smoke in the airplane during cruise flight, and weather conditions consisting of haze/smoke…NTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…NTSB ATL02LA127Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lawrenceburg, TNThe pilot's failure to secure the fuel cap after refueling that resulted in fuel siphoning from the right main fuel tank and the subsequent fuel supply exhaustion, and the total loss of engine power. The airplane was damaged during the forced landing to a…NTSB ANC02IA093Incident · Serious injuriesIncident investigationFinal reportPiper PA-31-350 · Talkeetna, AKThe passenger's incapacitation during a high altitude flight due to a loss of consciousness as the result of a pre-existing cardiovascular condition. A contributing factor in the incident was the operator's improper use of disposable oxygen masks without a…NTSB NYC02IA117Incident · Minor injuriesIncident investigationFinal reportDornier 328 · Washington, DCThe ground service personnel's failure to follow company procedure, which resulted in the flight attendant sustaining a serious injury.NTSB LAX02LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Henderson, NVThe pilot's misjudged landing flare during an autorotation, which resulted in a hard landing. The pilot's failure to follow the listed emergency procedures in the rotorcraft flight manual and the partial failure of the rotor system's drive belts were factors.NTSB NYC02LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Fairfield, ILThe first officer's abrupt level off.NTSB CHI02LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Lake in Hills, ILIt was not possible for the pilot to land the airplane at a proper touchdown point during the aborted takeoff and unsuitable terrain was encountered off the end of the runway. Factors associated with the accident were a proper climb rate was not achieved…NTSB CHI02LA117Accident · Serious injuriesLimited investigationFinal reportCessna 411 · Lee's Summit, MOThe pilot failed to maintain control of the airplane during the inital takeoff climb. Factors associated with the accident were the pilot's inadequate preflight of the airplane, the separation of the emergency exit, and the pilot's lack of a multi-engine…NTSB FTW02LA138Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Alsatia, LAThe main rotor contact to the tail boom resulting from the pilot leaving the helicopter unattended while the rotors were engaged.NTSB LAX02LA137Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe flight instructor's inadequate remedial action following the onset of ground resonance.NTSB MIA02TA082Accident · Serious injuriesFinal reportAerospatiale SA319B Alouette III · Altoona, FLThe intentional operation of the helicopter with known deficiencies in equipment (inoperative normal brakes), and the pilot's improper use of the cyclic flight controls after the helicopter started rolling following touchdown.NTSB IAD02LA040Accident · Serious injuriesLimited investigationFinal reportCessna T310R · Mount Holly, NJThe pilot's misjudgment of distance, his subsequent improper recovery from a bounced landing, and the failure to maintain airspeed which resulted in an inadvertent stall.NTSB IAD02LA039Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Atlantic Ocean (Atlantic Ocean)The airplane's encounter with turbulence, while climbing to an assigned altitude.NTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…NTSB FTW02LA088Accident · No injuriesLimited investigationFinal reportFokker F-28 MK-100 · Dallas, TXThe ground crew inadvertent application of deicing fluid in the auxiliary power unit resulting in an overspeed and turbine wheel burst. A contributing factor was the gusty wind.NTSB ANC02IA011Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-340-300 · Anchorage, AKThe captain's selection of a taxiway instead of a runway for takeoff and the flightcrew's inadequate coordination of the departure, which resulted in a departure from a taxiway. A factor in the incident was inadequate airline operator's procedures that did…