NTSB investigations, 1998
25 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\") = 1998
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") = 1998 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 DEN99LA028Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Canon City, COThe glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.NTSB NYC99IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York, NYThe Cessna pilot's incorrect visual identification of the Boeing 737's altitude, and decision to take evasive action that was not required, which resulted in the two airplanes coming within 500 feet horizontally, and 0 feet vertically of one another.NTSB FTW99IA024Incident · 1 fatalIncident investigationFinal reportPiper PA-23-235 · Mineral Wells, TXThe pilot-in-command's incapacitation due to cardiovascular disease.NTSB MIA99LA026Accident · 1 fatalLimited investigationFinal reportSaab-Scania 340A · Memphis, TNThe ground crewmembers inadvertent walking into the path of a rotating propeller resulting in her being struck and fatally injured.NTSB NYC99LA022Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYThe driver's failure to maintain control of the belt loader. A factor in the accident was the precipitation which may have contributed to the driver's foot slipping off the brake and onto the accelerator, as he approached the airplane.NTSB DEN99TA013Accident · No injuriesFinal reportAir Tractor AT-400 · Aztec, NMThe pilot's inadequate preflight inspection of the airplane. Factors were the unsecured oil dipstick, the loss of engine oil pressure necessitating a precautionary landing on unsuitable terrain, and the collision with the tree.NTSB NYC99LA013Accident · Serious injuriesLimited investigationFinal reportGoodyear Aerospace GZ-20-A · Bedford, MAThe separation of the pull-in-line. A factor in the accident was the gusting winds.NTSB FTW99LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Tomball, TXThe pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.NTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.NTSB IAD98LA105Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Freehold, NJThe passenger's failure to secure himself during landing.NTSB NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.NTSB NYC98LA199Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly AX-9 · Brookhaven, NYThe failure of the passenger to comply with the pilot briefing, and properly brace herself for landing.NTSB LAX98LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Page, AZFailure of the pilot to verify throttle position and/or obtain qualified assistance while hand propping the aircraft engine.NTSB CHI98LA302Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Columbus, INthe pilot-in-commands failure to maintain airspeed and the subsequent stall/mush. Factors associated with the accident were the open baggage door and the inadequate aircraft preflight.NTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…NTSB NYC98LA143Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Bedford, PAThe pilot's inadequate preflight inspection in which he failed to secure the oil filler cap, and his misjudgment of distance and altitude from the runway.NTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).NTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.NTSB NYC98LA130Accident · No injuriesLimited investigationFinal reportCessna 172R · Milford, NYThe pilot's decision to intentionally fly below wires, which resulted in the collision with trees. A factor in the accident was the soft grass airstrip.NTSB ANC98LA074Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe failure of the right main landing gear leg due to fatigue cracking. A factor associated with this accident is the inadequate inspection procedure specified by the manufacturer.NTSB CHI98LA176Accident · Minor injuriesLimited investigationFinal reportWaters Vortex · Monroe, WIthe pilot's failure to maintain rotor RPM. A factor associated with the accident was the soft terrain on which the gyrocopter touched down.NTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.NTSB MIA98LA161Accident · No injuriesLimited investigationFinal reportRevolution MINI-500 · Villa Rica, GAThe pilot's choice of landing area during a precautionary landing adjacent to the runway. This resulted in an in-flight collision of the left skid with a rock during a cyclic flare, loss of directional control, and subsequent collision of the main rotor blade…NTSB FTW98IA196Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-51 · Brownsville, TXThe flightcrew experienced physical impairment resulting from an accumulation in the cockpit of carbon dioxide fumes produced by dry ice, a hazardous material, carried in the main cargo compartment.NTSB MIA98LA148Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLfailure of the flight crew to maintain main rotor RPM during a landing touchdown, which resulted in the main rotor blades contacting the tailboom.