NTSB investigations, 1996
36 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\") = 1996
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") = 1996 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 LAX97LA073Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-15 · Las Vegas, NVthe ramp agent's failure to maintain a good situational awareness of the push-back. A factor was the dark night lighting conditions and the general communication failure of the ground push-back crew.NTSB LAX97IA056Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAa laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.NTSB CHI97IA033Incident · No injuriesIncident investigationFinal reportBoeing 767-300ER-33A · Chicago, ILthe approach controller's failure to issue the frequency change to the flightcrew, and the pilot landing without clearance. A factor relating to this incident is the pilot's decision to land without clearance.NTSB FTW97LA047Accident · No injuriesLimited investigationFinal reportCessna 182E · Alamosa, COaircraft damage for undetermined rteasons.NTSB LAX97LA034Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Flagstaff, AZAn uncommanded main rotor blade to tail boom contact due to a 'blowback' phenomena after a successful preplanned autorotation by the pilot to a high density altitude airport with a test aircraft designed at a maximum gross weight.NTSB FTW97LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Watkins, COThe flight instructor's improper decision to attempt a hovering autorotation during gusty wind conditions. A factor was the gusty wind.NTSB LAX97LA016Accident · No injuriesLimited investigationFinal reportWaco QCF · Big Bear City, CAthe pilot's improper response to a perceived in-flight emergency by abruptly retarding the throttle and failing to properly flare the airplane during the aborted takeoff. The pilot's improper perception of the source of smoke was a related factor.NTSB IAD97LA004Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Krosno KR-03A · Kutztown, PAthe glider pilot's improper decision to takeoff despite the presence of a glider winch cable lying on the runway area, which led to the glider snagging the winch cable during the takeoff roll and a subsequent forced landing. A related factor was: the airport…NTSB FTW97LA022Accident · Serious injuriesLimited investigationFinal reportThunder and Colt 90 · Albuquerque, NMThe passenger's failure to follow instructions for disembarking.NTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.NTSB FTW97LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Colorado Spgs, COthe student pilot attempting to exit the runway onto a taxiway at excessive speed. A factor was the pilot's failure to land the aircraft in the proper touchdown zone.NTSB FTW97IA003Incident · No injuriesIncident investigationFinal reportBeech 1900D · Pueblo, COPartial incapacitation of the flightcrew for unknown reasons.NTSB NYC97LA084Accident · No injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-S · Wadsworth, OHThe pilot's inadvertent activation of the speed brakes while being towed for takeoff. Subsequently, the glider pilot lost sight of the tow airplane due to excessive altitude, released the tow rope, and performed an off airport landing during which the glider…NTSB FTW96LA394Accident · Serious injuriesLimited investigationFinal reportSaab-Scania SF-340B · Fort Smith, ARthe passenger fell for undetermined reasons, while disembarking from the airplane.NTSB FTW96LA355Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Clinton, LAthe instructor pilot's failure to follow recommended procedures to properly brace himself in preparation for landing.NTSB ANC96LA123Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Dillingham, AKThe pilot's failure to maintain an adequate visual lookout in order to see and avoid all ground personnel, his failure to follow company procedures and directives regarding Public Protection, and his disregard of the unsafe/hazardous conditions created by…NTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…NTSB LAX96LA277Accident · No injuriesLimited investigationFinal reportRobinson R22B · Morgan Hill, CAThe student's improper reaction to an engine/main rotor overspeed condition, and his failure to achieve the proper zero airspeed nose high attitude during a touchdown from an autorotation.NTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…NTSB NYC96LA150Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Providence, RIthe passenger inadvertently lost his balance and fell, while deplaning.NTSB CHI96LA206Accident · Serious injuriesLimited investigationFinal reportMitchell T Champabria · Kalamazoo, MIthe pilot's improper positioning of the throttle, while hand propping the aircraft engine, and his failure to either obtain proper assistance or properly secure the airplane.NTSB FTW96IA240Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COphysical impairment of the captain due to a probable cardiac event.NTSB ANC96LA083Accident · No injuriesLimited investigationFinal reportChampion 7AC · Clear, AKthe pilot's inadequate preflight inspection in that he failed to ensure that the cabin door was properly secured for takeoff. Factors associated with the accident were: the open cabin door and rough/uneven terrain.NTSB FTW96TA222Accident · No injuriesFinal reportMcDonnell Douglas MD-520N · Bethany, OKThe main rotor blades' contact with the tail boom due to gusting winds during rotor deceleration.NTSB FTW96LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Ft. Lupton, COthe pasenger's failure to follow the instructions given by the pilot during a briefing.NTSB FTW96LA194Accident · No injuriesLimited investigationFinal reportChampion 7AC · Pine Bluff, ARthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.NTSB FTW96LA172Accident · No injuriesLimited investigationFinal reportCessna 305A · Erie, COentanglement of the tow banner during banner pickup, and subsequent failure or inability to jettison the banner. A factor relating to the accident was: high gusty wind condition.NTSB SEA96FA071Accident · Minor injuriesField investigationFinal reportCessna U206E · Renton, WAthe pilot's initiation of a flight with a known disqualifying heart condition, and his subsequent inflight incapacitation from a heart attack. A factor relating to the accident was: the inability of the non-rated passenger (unqualified person) to attain a…NTSB FTW96FA143Accident · 1 fatalField investigationFinal reportCessna 150 · Muleshoe, TXimproper planning/decision by the student pilot, and his failure to take adequate remedial action after becoming lost and encountering a low fuel situation, which subsequently resulted in fuel exhaustion, loss of engine power, and a forced landing at night.…NTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.NTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.NTSB CHI96LA102Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Brighton, IAThe pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.NTSB CHI96LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Larned, KSFailure of the pilot to use adequate procedures for hand priming (hand propping) the engine.NTSB FTW96LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cushing, OKThe inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.NTSB LAX96LA093Accident · 1 fatalLimited investigationFinal reportBell 47-G5 · Pope Valley, CAthe pilot misjudged the clearance between the broadcaster and the truck resulting in the broadcaster's cables becoming entangled with the truck.NTSB FTW96LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Decatur, TXthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.