NTSB investigations, 1995
28 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\") = 1995
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") = 1995 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 BFO96LA031Accident · Minor injuriesLimited investigationFinal reportBellanca BL14-19-3 · Toledo, OHan improper splice of the magneto 'P' lead wires, and the pilot's improper positioning of the throttle and mixture controls while he rotated the propeller by hand.NTSB ANC96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kasilof, AKThe pilot's inadvertent liftoff, and an inoperative elevator that became jammed due to frozen slush/snow.NTSB BFO96LA024Accident · No injuriesLimited investigationFinal reportCessna 210J · Bellefontaine, OHThe pilot unknownly left the ignition switch in right magneto-only position, while moving the propeller by hand, which allowed an inadvertent start of the engine. The weak battery was a related factor.NTSB CHI96LA025Accident · No injuriesLimited investigationFinal reportBeech A90 · Wichita, KSfailure of the pilot to follow procedures/directives regarding the entrance door, which resulted the door coming open in flight.NTSB LAX96LA035Accident · Serious injuriesLimited investigationFinal reportBoeing 747-122 · Pacific Ocean (Pacific Ocean)the failure of the passenger to comply with the fasten seatbelt signs and the verbal directives of the flight and cabin crew.NTSB LAX96IA032Incident · Minor injuriesIncident investigationFinal reportBoeing 737-5H4 · Las Vegas, NVThe flying pilot's inadvertent exposure to an unidentified ground-based laser beam. A factor in the incident is the lack of appropriate standards by the FAA and FDA for laser light exposure levels to aircrew in navigable airspace.NTSB FTW96FA030Accident · 1 fatalField investigationFinal reportBeech 95-B95 · Tulsa, OKInadequate preflight by the pilot by failing to remove the flight control lock and failing to check the flight controls before takeoff, and the pilot's failure to abort the takeoff.NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…NTSB SEA96LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Laurel, MTthe student pilot's improper planning/decision, which resulted in inadequate altitude/clearance from hangar buildings and a subsequent emergency landing, while attempting to evade a flock of geese. The flock of geese was a related factor.NTSB MIA95IA238Incident · Minor injuriesIncident investigationFinal reportBoeing 737-400 · Fort Lauderdale, FLInadequate written maintenance procedures addressing steps to be followed in the event of a component failure during an engine wash. The emergency slides failed to deploy due to improper installation by company maintenance personnel.NTSB CHI95LA340Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235B · Highland, ILa communication misunderstanding between the tow pilot and the glider pilot. Factors related to the accident were: the tow rope becoming entangled, excessive taxispeed by the tow pilot, and the unavailability of a dispatcher.NTSB SEA95LA217Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Morgan, UTFailure of the pilot to maintain adequate airspeed, while maneuvering to land after a low altitude tow release, which resulted in a stall/spin and collision with terrain.NTSB FTW95LA309Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Belen, NMThe parachutist's failure to follow procedures on exiting the aircraft. A factor was the parachutist's incapacitation due to hitting his head on the doorway floor.NTSB MIA95TA188Accident · No injuriesFinal reportMcDonnell Douglas H369 · Panama City, FLThe pilot-in-command's improper aft application of cyclic control during a simulated touchdown autorotation on landing flare touchdown, resulting in the main rotor blades colliding with the tail boom assembly. Contributing to the accident was the improper…NTSB LAX95LA254Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's improper planning/decision and failure to obtain or maintain adequate airspeed during takeoff. A factor relating to the accident was: the high density altitude.NTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…NTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.NTSB CHI95LA197Accident · Minor injuriesLimited investigationFinal reportGriner Bushby Mustang I · Shelbyville, INthe pilot's allowing the airplane to inadvertently liftoff. A factor was a malfunction of the flight control system.NTSB MIA95IA134Incident · Serious injuriesIncident investigationFinal reportBoeing 727-227 · Brooksville, FLAn elderly passenger losing his balance as the aircraft operated in smooth air.NTSB BFO95FA050Accident · 1 fatalField investigationFinal reportCessna 172F · Tappahanock, VAThe student pilot's misjudgment of distance/speed during the approach to land, and her failure to go around while there was still sufficient runway remaining. Factors related to the accident were: inadequate supervision by the flight instructor, the student's…NTSB BFO95LA046Accident · No injuriesLimited investigationFinal reportSchweizer SC2-33A · North Adams, MAthe failure of the tow rope during the initial climb. Related factors are the gusty wind conditions, the low altitude at which the failure occurred, the tailwind during the emergency landing roll, and the CFI's intentional ground loop due to the obstacle…NTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.NTSB ATL95LA080Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Brownsboro, ALThe student pilot's inadvertent use of spoilers during takeoff. Factors related to the accident were: the glider instructor's failure to identify the extended spoilers, and the proximity of trees in the emergency landing area.NTSB NYC95LA083Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Jamaica, NYexcessive flames/tailpipe fire from the number 2 engine for an unknown reason, which required an emergency evacuation.NTSB FTW95IA148Incident · 1 fatalIncident investigationFinal reportDouglas DC-9-32 · Abilene, TXIncapacitation of the first officer due to a heart attack.NTSB FTW95LA103Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · Dallas, TXThe flight attendants' lack of supervision of deplaning passengers. A factor was lack of supervision by accident victims mother.NTSB MIA95LA058Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Natchez, MSInadequate preflight of the helicopter by the pilot for his failure to separate the dolly before attempting flight.NTSB LAX95FA076Accident · 1 fatalField investigationFinal reportCessna 208B · Flagstaff, AZThe pilot's failure to properly configure the aircraft fuel system prior to takeoff, and his failure maintain an adequate terrain clearance altitude while maneuvering to return to the airport. Factors in the accident were the dark night lighting conditions,…