NTSB investigations, 2000
41 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\") = 2000
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") = 2000 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 LAX01FA059Accident · 1 fatalField investigationFinal reportDehavilland DHC-6 · Sacramento, CAThe passenger committed suicide.NTSB NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.NTSB NYC01FA007Accident · 1 fatalField investigationFinal reportBeech E18S · Wash. Ct. House, OHAn undetermined event, which resulted in an off airport landing. A factor in this accident was the night light condition.NTSB NYC00LA269Accident · No injuriesLimited investigationFinal reportSaab 340B · Boston, MAThe operator's loss of control of the belt-loader, due to his improper decision to depress the vehicle's accelerator in the proximity of the airplane.NTSB SEA00LA177Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, WADamage to aircraft under unknown circumstances.NTSB CHI00LA268Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Baraboo, WIthe unexpected turbulence encountered by the airplane.NTSB NYC00IA231Incident · No injuriesIncident investigationFinal reportFokker F-100 · Norfolk, VAThe failure of the airplane's ground/flight switch and a malfunction of the thrust reverser deploy switch, which resulted in an in-flight thrust reverser deployment.NTSB MIA00LA232Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Alabaster, ALa loss of engine power for undetermined reasons resulting in a forced landing and subsequent impact with the ground. A factor in this accident was that the pilot did not obtain the proper touchdown point upon landing and landed long.NTSB SEA00TA149Accident · No injuriesFinal reportShort SD3-30 200 · Elk City, IDEntanglement of air-dropped cargo parachute with the aircraft's horizontal stabilizer, resulting in damage to the horizontal stabilizer.NTSB MIA00LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Immokalee, FLThe inadequate supervision of the pilot rated student by the CFI for her failure to note that the fuel selector was positioned to an empty fuel tank. Also, failure of the CFI to attain the proper rate of descent at touchdown resulting in a hard landing.…NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.NTSB LAX00LA223Accident · No injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the mechanic to refasten the cowling door prior to returning the aircraft to service.NTSB LAX00FA213Accident · No injuriesField investigationFinal reportCessna 414A · Prescott Valley, AZThe pilot's physical impairment due to the cumulative effects of carbon monoxide from engine exhaust by-products, carbon monoxide from heavy tobacco use, and the loss of an undetermined amount of cabin pressurization. A factor in the loss of pressurization…NTSB MIA00LA175Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, NCThe inadequate supervision of the student pilot by the CFI for his failure to note that the student was performing a go-around from a low pass with 30-degree of flaps extended instead of the POH recommended 20-degrees. A factor in the accident was the failure…NTSB MIA00LA174Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Milledgeville, GAThe operation of the airplane by the pilot-in-command in an over gross weight condition, the failure of the pilot to maintain airspeed (Vs) after takeoff, and the intentional stalling of the airplane by the pilot-in-command for his attempting to bank while…NTSB MIA00LA169Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Nashville, TNThe passenger's onboard disturbance and self-evacuation from the parked aircraft, resulting in injuries. A factor in the accident was the lack of backup electrical power to the terminal which necessitated a lengthy ground hold.NTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.NTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…NTSB IAD00LA042Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Gettysburg, PAThe pilot's improper pre-flight which resulted in the fuel strainer valve being left in the open position.NTSB NYC00LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Wellington, OHThe pilot's failure to maintain aircraft control. A factor was the pilot's improper in-flight decision to abort the initial climb due to an open canopy.NTSB DEN00LA088Accident · No injuriesLimited investigationFinal reportBeech V35B · Erie, COInadvertent cut off of the mixture by the pilot. Factors were: The passenger door opening, the pilot's inexperience in make and model, and rough, uneven terrain in the landing area.NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.NTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…NTSB NYC00LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lancaster, OHThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot's decision to operate the airplane over the maximum gross weight and his improper landing flare.NTSB SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.NTSB LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.NTSB LAX00FA151Accident · 1 fatalField investigationFinal reportBeech B36TC · Fullerton, CAThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an inadvertent stall/spin. Contributing factor was the pilot's diverted attention with the loss of engine power from his inadvertent activation of the auxiliary…NTSB SEA00IA062Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Seattle, WAContaminated air being ducted into the aircraft's cabin from the engine exhaust of a nearby ground power cart.NTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.NTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.NTSB ANC00IA034Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Fairbanks, AKA delayed rotation during takeoff for an undetermined reason.NTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…NTSB LAX00LA100Accident · No injuriesLimited investigationFinal reportBell 47G5 · Riverbank, CAthe pilot's failure to verify that ground personnel had disconnected the loading hose from the hopper before takeoff, resulting in restricted directional control and a hard landing.NTSB NYC00IA078Incident · Minor injuriesIncident investigationFinal reportSaab-Scania 340B · Boston, MAThe vehicle driver's inadequate visual lookout.NTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…NTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.NTSB FTW00LA069Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spring Branch, TXThe pilot's delay in aborting the takeoff. A factor was the open cabin door.NTSB CHI00LA059Accident · No injuriesLimited investigationFinal reportCessna 208B · Warsaw, INthe misjudged unsafe/hazardous condition by the pilot. Factors to the accident were the precautionary landing being performed by the pilot and the snow covered runway. Additional factors were the dark night, the snowing weather condition, the airport…NTSB LAX00LA063Accident · No injuriesLimited investigationFinal reportCessna 172G · Victorville, CAThe failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.