NTSB investigations, 1999
32 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\") = 1999
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") = 1999 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 MIA00LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pikeville, NCThe inadequate supervision of the private-rated pilot by the certified flight instructor for allowing the airplane to impact terrain during a simulated forced landing procedure to an open field.NTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.NTSB ANC00IA010Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the flight crew to provide a recommended landing traffic advisory, and the failure of flight service station personnel to provide a flight advisory to the arriving airplane concerning men and equipment operating on the runway. Factors in the…NTSB ATL00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe student pilot's in-flight decision that resulted in the loss of engine power due to fuel exhaustion after he became lost and disoriented. A factor was the two fences.NTSB FTW00LA017Accident · No injuriesLimited investigationFinal reportWright Avid Flyer Mark IV · Seabrook, TXThe pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.NTSB MIA00LA010Accident · No injuriesLimited investigationFinal reportCessna 150M · Bunnell, FLThe erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB MIA00LA008Accident · 2 fatalLimited investigationFinal reportEddie A. Smith KR-2 · Bell Buckle, TNThe poor in-flight planning decision by the pilot-in-command for continuing the flight with inadequate fuel supply and the inadvertent stall by the pilot-in-command following total loss of engine power due to fuel exhaustion. Findings in the accident were the…NTSB NYC99LA229Accident · No injuriesLimited investigationFinal reportCessna 305A · Warehouse Point, CTThe pilot's misjudgment of the clearance between the airplane and the banner loop during banner pickup.NTSB LAX99LA264Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA 20-A1 · San Carlos, CAThe release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.NTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…NTSB ANC99TA090Accident · No injuriesFinal reportBell 206B · Deadhorse, AKA failure of the pilot-in-command to perform an adequate preflight inspection, and remove a rotor blade tie-down strap.NTSB CHI99LA209Accident · No injuriesLimited investigationFinal reportCessna 180A · White Bear Lake, MNthe pilot's inability to get the airplane to climb for undetermined reason, and the pilot landing the floatplane on the lake with the wheels extended. Factors contributing to this accident were the pilot's failure to perform a before landing checklist,…NTSB MIA99LA179Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Wimauma, FLa passenger deplaning the airplane while the engine was running struck the propeller.NTSB FTW99LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Panhandle, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the noise heard by the pilot that resulted in his decision to execute a precautionary landing.NTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.NTSB LAX99LA212Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)intentional tampering/altering of a galley lift interlock microswitch by unknown persons.NTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…NTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.NTSB SEA99LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Omak, WAThe pilot's failure to properly secure the aircraft before hand-propping.NTSB DCA99IA058Incident · No injuriesIncident investigationFinal reportAirbus Industrie 300-600 · Miami, FLUncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…NTSB MIA99LA131Accident · 1 fatalLimited investigationFinal reportPiper J-3C · Jackson, MSThe failure of the airshow aerial performer to maintain a grip on the airplane's externally mounted rope ladder for unknown reasons and his failure to install and use a safety line resulting in his fall to earth. A factor in the accident was the sudden…NTSB LAX99LA181Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · La Verne, CAThe in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.NTSB NYC99LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Boston, MAThe belt-loader driver's loss of control of the vehicle, and his failure to follow published procedures for approaching the airplane with the belt-loader.NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB NYC99LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Newark, NJThe flight attendant's failure to follow cabin door opening procedures.NTSB MIA99LA077Accident · Minor injuriesLimited investigationFinal reportLee S. Harvard LONG-EZ · Spring Hill, FLThe failure of the pilot to insure the canopy was closed prior to takeoff resulting in an aborted takeoff, overheating of the brakes, and a roll over when the aircraft was turned off the runway into the grass in an attempt to stop.NTSB IAD99LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Medina, OHWas the pilot's failure to remove snow from the horizontal stabilator prior to take-off and his improper decision to depart downwind. Factors in the accident were the heavy snow squall and tailwind.NTSB NYC99IA056Incident · No injuriesIncident investigationFinal reportPiper PA42-1000 · Lexington, KYImproper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.NTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.NTSB NYC99LA235Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · New York, NYInadequate counterbalancing to compensate for the weight of the cargo door.NTSB LAX99IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Phoenix, AZThe failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…