NTSB investigations
902 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 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 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 NYC08LA059Accident · 1 fatalLimited investigationFinal reportWootton, John Aero Canard · Statesville, NCAn inadvertent opening of the canopy during takeoff.NTSB LAX08CA014Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Napa, CAThe pilot's failure to latch the cargo door during preflight.NTSB DEN08IA022Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73F · Wichita, KSFailure of the recirculation fan motor end ball bearing.NTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.NTSB LAX07CA282Accident · Minor injuriesData collectionFinal reportPiper J5A · Turlock, CAThe pilot's failure to properly and adequately tie down the airplane during the engine start operation.NTSB CHI08CA011Accident · No injuriesData collectionFinal reportCessna 172P · Belleville, ILthe design limits of the aircraft being exceeded by a previous pilot during an unknown phase of flight.NTSB MIA07LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wimauma, FLThe failure of the pilot to maintain airspeed while maneuvering for a precautionary landing following a reported loss of engine power for undetermined reasons.NTSB OPS07IA010Incident · No injuriesIncident investigationFinal reportLearjet 35 · Washington, DCThe probable cause of this incident was the IAD tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll. Additionally, the…NTSB CHI07CA313Accident · No injuriesData collectionFinal reportHasch Vans RV6 · Salem, OHThe loss of engine power due to the blocked cooling and induction systems because of the pilot in command's failure to remove the cowling covers before the flight. Factors were the pilot's misjudged landing glidepath, the pilot rated passenger's inability to…NTSB NYC07FA217Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Syria, VAThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain aircraft control. Contributing to the accident was the dark night conditions.NTSB NYC07LA202Accident · No injuriesLimited investigationFinal reportLearjet 60 · Westhampton, NYThe captain's failure to properly align the airplane prior to touchdown.NTSB DEN07CA139Accident · No injuriesData collectionFinal reportCessna A185F · Lake City, COThe pilot's improper preflight planning, his inability to attain short field takeoff performance, and his intentional maneuvering of the airplane into bushes and a fence during the aborted takeoff. Factors contributing to the accident were the high density…NTSB SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.NTSB MIA07CA119Accident · Serious injuriesData collectionFinal reportBoeing 777-232 · Atlanta, GAThe flight attendant's inadvertent misstep on a ladder and falling during pushback resulting in serious injuries.NTSB DFW07LA155Accident · 1 fatalLimited investigationFinal reportBoeing 737-232 · Tunica, MSGorund service personal's removal of the portable stairway prior to the main cabin door being secured. Factors were the high winds and heavy rain.NTSB NYC07CA163Accident · Minor injuriesData collectionFinal reportCessna 182K · Matincus Island, MEAn evasive maneuver to avoid a bird, while on final approach, which resulted in an in-flight collision with trees.NTSB ATL07CA101Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus-CS · Freehold, NYThe pilot's inadvertent activation of the tow release handle at a low altitude following an encounter with turbulence.NTSB ATL07CA094Accident · No injuriesData collectionFinal reportCessna C152 · Miami, FLThe pilot's loss of consciousness while on final approach to land, resulting in an uncontrolled descent, and a hard landing on the runway.NTSB LAX07IA191Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZAn out of rig/jammed door. Contributing to the incident was the operator's inadequate maintenance program and the airframe manufacturer's inadequate response to the issue.NTSB SEA07LA147Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Troy, ORThe inadvertent entanglement of the crewmemeber's helmet's communication cord with the structure of the helicopter during the helicopter's ascent, which resulted in the crewmember being elevated above ground level before the helmet's cord separated, resulting…NTSB LAX07CA176Accident · No injuriesData collectionFinal reportI.C.A.-Brasov IS-28B2 · Mokuleia, HIthe pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.NTSB LAX07CA172Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Los Alamitos, CAfailure of the towrope during the initial climb out.NTSB NYC07LA121Accident · No injuriesLimited investigationFinal reportDouglas DC-9-31 · Syracuse, NYThe senior ground agent's failure to follow written procedures and directives.NTSB LAX07LA189Accident · Serious injuriesLimited investigationFinal reportBoeing 757-24APF · Burbank, CAThe tow tractor driver's and mechanic's diverted attention resulting in the airplane rolling over the mechanic's foot. Also causal was the mechanic's failure to maintain clearance from the nose landing gear.NTSB NYC07CA103Accident · No injuriesData collectionFinal reportChampion 7ECA · Nashua, NHThe pilot's misjudged altitude while maneuvering for a banner pickup, which resulted in the banner rope becoming entangled in the airplane's landing gear, and a hard landing, during the ensuing emergency off airport landing.NTSB ATL07IA078Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Atlanta, GAThe mechanics failure to follow procedures and directives in securing the lower engine cowling after maintenance, and the failure of the first officer to follow the checklist to ensure the engine cowling was secured during the walk around inspection resulting…NTSB SEA07CA117Accident · No injuriesData collectionFinal reportCessna U206G · Glendale, AZThe pilot's failure to properly latch the door prior to takeoff.NTSB MIA07LA059Accident · No injuriesLimited investigationFinal reportRobinson R-44-II · Miami, FLThe pilot's failure to maintain sufficient rotor rpm during an autorotative landing, which resulted in a hard landing and separation of the tailboom.NTSB CHI07CA085Accident · Minor injuriesData collectionFinal reportPolcyn Long-EZE · St. Charles, MOA loss of engine power for undetermined reasons. A factor in the accident was the inadvertent lift-off that occurred during the high speed taxi checks.NTSB NYC07CA070Accident · Minor injuriesData collectionFinal reportSchweizer 269-C · Columbus, PAThe pilot's improper decision to continue the landing attempt in whiteout conditions, which resulted in his disorientation, and the helicopter's subsequent dynamic rollover. Factors included the whiteout conditions, and the pilot's inadequate weather…NTSB LAX07CA086Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-3C · Jean, NVthe tow hook jamming and failing to release from the glider.NTSB DEN07IA058Incident · No injuriesIncident investigationFinal reportBoeing 737-522 · Denver, COThe snowplow driver's failure to follow procedures/directives by crossing an active runway without clearance, resulting in a runway incursion and near collision with an airplane during its landing roll.NTSB MIA07CA040Accident · Serious injuriesData collectionFinal reportJim Garrison N11 · Titusville, FLThe failure of the pilot to abort the takeoff after becoming airborne during taxi testing, and the failure of the pilot to maintain airspeed after becoming airborne resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a tree.NTSB OPS07IA002Incident · No injuriesIncident investigationFinal reportBoeing 757-212 · Atlanta, GAThis incident was caused by the local controller's issuance of an improper takeoff clearance to DAL1606. Contributing was the failure of the oncoming and outgoing local controllers to provide and receive a complete position relief briefing; and the oncoming…NTSB SEA07LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fresno, CAThe design stress limits of the airframe were exceeded by an unknown pilot.NTSB SEA07CA027Accident · No injuriesData collectionFinal reportPiper PA-12 · Antelope Island, UTThe pilot's excessive braking during a precautionary landing at an off-airport landing area. A contributing factor was the pilot's non-standard modification of the oil cooler, which resulted in high engine oil temperature.NTSB DFW07LA024Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pocasset, OKThe "abnormally high" oil temperature indication and smoke in the cabin for undetermined reasons. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB NYC07IA023Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland EC135T1 · Harrisburg, PAThe pilot's inadequate preflight preparation, which resulted in the cyclic stick lock not being disengaged prior to lift-off, and his subsequent inability to control the helicopter. Contributing to the accident was the operator's inadequate procedures, the…NTSB DCA07IA008Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Seattle, WAthe flight crew's failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the incident was the flight crew's self-induced pressure to heed the takeoff clearance during a period of increased workload.NTSB NYC07IA015Incident · No injuriesIncident investigationFinal reportBoeing 757-224 · Newark, NJThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Contributing was the night lighting conditions.NTSB MIA07LA009Accident · 2 fatalLimited investigationFinal reportMike Smilee CGS Hawk II Arrow · Crystal Springs, FLThe failure of the non-rated pilot to maintain airspeed. A finding in the accident was a malfunction of the ignition switch.NTSB DEN07CA013Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Monticello, UTan airframe vibration for reasons undetermined, resulting in the pilot performing a precautionary landing, and obstacle clearance not possible.NTSB NYC07FA007Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau Gmbh 300 · Culpeper, VAThe pilot’s disorientation while performing an aerobatic maneuver, which resulted in the airplane’s inadvertent impact with the ground. Contributing to the accident was the pilot’s overuse of prescription medication.NTSB NYC06CA225Accident · No injuriesData collectionFinal reportPiper PA-25-180 · Mount Holly, NJThe pilot's improper starting procedure, which resulted in an uncontrolled taxi, and collision with a parked airplane.NTSB LAX06TA284Accident · No injuriesFinal reportBell 212 · Happy Camp, CAFailure of compressor second stage stator vane for undetermined reasons while maneuvering.NTSB NYC06IA226Incident · No injuriesIncident investigationFinal reportCessna 206F · Matinicus Islnd, MEAn engine kick back of undetermined origin during engine start.NTSB DCA06MA064Accident · 49 fatalClass 1 · MajorFinal reportBombardier CRJ-100 · Lexington, KYthe flight crewmembers's failure to use available cues and aids to identify the airplane's location on the airport surface during taxi and their failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the…NTSB NYC06LA197Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Bellefonte, PAImproper maintenance of the throttle linkage, which resulted in a lack of engine power during takeoff. Factors were the pilot's premature retraction of the flaps, an improper elevator trim setting, a high gross takeoff weight, and a high density altitude;…NTSB CHI06CA219Accident · Serious injuriesData collectionFinal reportShempp-Hirth Discuss B · Tipton, INThe glider pilot's improper in-flight decision to continue searching for thermal lift, instead of landing when the glider was in range of a suitable landing area. Contributing factors to the accident was the lack of thermal lift which resulted in a hard…NTSB NYC06LA191Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Newark, NJThe captain's failure to follow company procedures, which resulted in pushback with the parking brake set. A factor was the larger than preferred tug.