NTSB investigations, 1990
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\") = 1990
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") = 1990 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 SEA91LA034Accident · 1 fatalLimited investigationFinal reportBeech D50C · Snohomish, WAThe obstruction (protruding door support bracket) in the doorway of the aircraft; failure of the company/operator personnel, the pilot, and the skydivers to assure that the doorway was clear of obstructions; and subsequent snagging of the d-ring, which…NTSB MIA91LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Pierce, FLThe incorrect cyclic control input by the student during the touchdown autorotation landing and failure of the CFI to correct this before the helicopter touched down.NTSB CHI91IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Detroit, MIThe inadequate deicing procedures instituted by company management.NTSB MIA91LA027Accident · 2 fatalLimited investigationFinal reportCessna 172P · Atlantic Ocean (Atlantic Ocean)Delay of the pilot to obtain assistance and, as a result, he ditched the airplane near a boat due to a low fuel supply.NTSB ATL91FA008Accident · 2 fatalField investigationFinal reportBeech A36 · Georgetown, SCThe pilot-in-command's loss of consciousness during flight. The reason for the loss of consciousness could not be determined.NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.NTSB CHI90DEC05Accident · No injuriesFinal reportSchleicher ASW-22 · Richmond, MIThe pilot's premature retraction of the flaps allowing the glider to settle into an unusually low tow altitude.NTSB DCA90IA048Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe pilot(s) allowed the aircraft to rotate to an excessive nose high attitude, either during a takeoff or landing.NTSB LAX90LA270Accident · No injuriesLimited investigationFinal reportCessna 172G · Trinity Center, CAThe pilot's excessive airspeed and his failure to touchdown at the proper location on the runway.NTSB SEA90LA156Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · Coeur D'Alene, IDPassenger spilling a hot cup of coffee in her lap while the flight was in cruise flight.NTSB BFO90DIG02Accident · Minor injuriesFinal reportCessna 182J · Frederick, MDFailure of the pilot to assure that the magneto (ignition) switch was in the proper position. A factor related to the accident was: partial failure of the magneto switch, which allowed the key to be removed, though the switch was not in the 'off' position.NTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…NTSB LAX90FA250Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Pleasant Valley, AZAn inadvertent spin after failure to maintain airspeed. Factors include inadequate preflight, and an improperly maintained lap belt.NTSB FTW90LA133Accident · 1 fatalLimited investigationFinal reportBell 206B · San Antonio, TXThe lineman/flight crewman not following procedures.NTSB MIA90LA147Accident · No injuriesLimited investigationFinal reportCessna 150F · Pensacola, FLInstructor pilots failure to assure that the flaps were in the proper position for takeoff resulting in reduced climb performance. This resulted in the forced landing, during which, the airplane collided with a power line, stalled, then crashed to the ground.NTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.NTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.NTSB ANC90LA078Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7DC · Elmendorf, AKFailure of the pilot to properly tie down and chock the aircraft and/or obtain proper assistance, and his failure to properly set the throttle, while hand propping to start the engine.NTSB CHI90LA134Accident · No injuriesLimited investigationFinal reportCessna 172N · Jeffersonville, INThe engine started for an undetermined reason, when the prop was moved after the pilot experienced an inoperative starter. (Most probably, there was either an isolated/intermittent problem in the ignition system or the pilot did not move the magneto switch…NTSB MIA90LA123Accident · Serious injuriesLimited investigationFinal reportBell TH-13T · Biloxi, MSThe passenger's intentional act of jumping in the air with his arm raised while under the main rotor.NTSB LAX90LA189Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIImproper supervision and absence of assistance by the company to passengers disembarking the helicopter.NTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.NTSB ATL90LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Gulf Shores, ALFailure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.NTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.NTSB MIA90LA076Accident · No injuriesLimited investigationFinal reportHughes 300C · Vero Beach, FLThe failure of the pilot in command/instructor pilot to maintain adequate rotor RPM after landing from a touchdown autorotation. A factor related to the accident was the gusty wind condition.NTSB DCA90MA019Accident · 73 fatalClass 1 · MajorFinal reportBoeing 707-321B · Cove Neck, NYThe failure of the flightcrew to adequately manage the airplane's fuel load, and their failure to communicate an emergency fuel situation to air traffic control before fuel exhaustion occurred. Contributing to the accident was the flightcrew's failure to use…NTSB NYC90IA050Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Philadelphia, PAThe flight crew of EAL121 taking off on a taxiway. Contributing was failure of the flight crew of eal 121 to maintain an adequate visual lookout during taxi and takeoff.NTSB NYC90LA046Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Kutztown, PAImproper decision of the glider pilot to exit the glider without positive assurance that the tow pilot had received his signal or that the glider was released from the tow plane. A related factor to the accident was: the lack of crew coordination between the…