NTSB investigations, 2005
33 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\") = 2005
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") = 2005 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 NYC06LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-800 · State College, PAThe pilot's improper touchdown and recovery from a bounced landing. Factors to the accident were the operator's failure to provide sufficient information on the use of autothrottles and bounced landing recovery techniques, along with the Federal Aviation…NTSB CHI06LA027Accident · No injuriesLimited investigationFinal reportAgusta A109-E · Robbinsdale, MNThe loss of lift for undetermined reasons.NTSB CHI06FA026Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ankeny, IAThe pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…NTSB CHI06CA028Accident · No injuriesData collectionFinal reportCessna 182 · Butler, MOThe damage to the horizontal stabilizer was a result of the inadvertent deployment of the skydiver's reserve parachute.NTSB NYC06CA020Accident · Minor injuriesData collectionFinal reportRobinson R44 · Bourne, MAThe inadvertent contact of a lift strap with the tail rotor during external load operations, which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the gusty wind conditions.NTSB NYC06CA022Accident · Serious injuriesData collectionFinal reportCameron Balloons O-90 · Bethlehem Twp., NJThe ground crewmember's inadvertent entanglement in the balloon's vent lines.NTSB CHI06LA016Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Covington, KYThe passenger falling while exiting the aircraft using the door-stair during normal deplaning.NTSB DFW06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-225 · San Antonio, TXThe captain's improper decision to maneuver a transport category airplane in a confined and unapproved area with engine thrust, which resulted in ground damage and personal injury to an individual.NTSB MIA06LA004Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff.NTSB MIA06CA003Accident · No injuriesData collectionFinal reportBeech 58 · Jacksonville, FLThe pilot's improper use of the normal brakes during the landing roll and his delay in performing a go-around resulting in an emergency descent/landing on grass past the departure end of the runway and subsequent collapse of the left main landing gear.NTSB IAD05CA141Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Louisville, KYThe ground crewman's failure to release the basket of the balloon when it resumed flight during the landing phase. A factor in the accident was the wet grass at the landing site.NTSB IAD05FA121Accident · 1 fatalField investigationFinal reportCessna 150M · Wht Sulfur Sprg, NYThe pilot's inadequate visual lookout during a precautionary landing, which resulted in collision with a wire and terrain. Factors in the accident were the pilot's inadequate in-flight planning which resulted in his becoming lost/disoriented, and a low fuel…NTSB IAD05LA112Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Mount Holly, NJThe flight instructor's delayed remedial action. A factor was the flight instructor's failure to ensure that both pilots knew who was performing the maneuver.NTSB ATL05CA131Accident · No injuriesData collectionFinal reportCessna 525A · Newnan, GAThe pilot's delay in aborting the landing and his failure to maintain obstacle clearance. Contributing factors were hydroplaning condition, and the localizer antenna.NTSB IAD05CA100Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Altoona, PAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with a hangar.NTSB ANC05LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Whittier, AKThe pilot's becoming lost/disoriented while maneuvering due to inadequate in-flight planning/decision making, which resulted in fuel exhaustion and a forced landing in tree-covered terrain. A factor contributing to the accident was fuel exhaustion.NTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.NTSB NYC05CA104Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fredericksburg, PAThe pilot's improper engine starting procedures, which resulted in the airplane taxiing unoccupied and impacting a light pole.NTSB ANC05CA084Accident · No injuriesData collectionFinal reportPiper PA-18 · Pamler, AKThe student pilot's failure to obtain/maintain adequate airspeed during takeoff-initial climb, which resulted in an in-flight collision with trees. Factors associated with the accident are a tailwind and diminished braking capability.NTSB NYC05IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330-301 · Boston, MAThe local east controller's failure to follow FAA Order 7110.65, para 3-9-8 and Boston Tower Order 7110.11, Standard Operating Procedures, which resulted in a runway incursion during takeoff involving two transport category airplanes.NTSB DCA05MA070Accident · 1 fatalMajor investigationFinal reportEmbraer 170 · Washington, DCThe inexperience of the driver (fleet service agent) in the operation of a belt loader, which resulted in the belt loader being driven under, and colliding with, the airplane.NTSB LAX05LA151Accident · 1 fatalLimited investigationFinal reportGulfstream 695A · North Las Vegas, NVThe incapacitation of the pilot.NTSB LAX05TA156Accident · No injuriesFinal reportSikorsky S-70A · Calabasas, CAfatigue of the forward keeper due to known flaws in the manufacturing process.NTSB SEA05CA079Accident · Minor injuriesData collectionFinal reportCessna 150 · Independence, ORThe pilot's failure to secure the airplane while starting the engine by hand-propping.NTSB MIA05LA080Accident · No injuriesLimited investigationFinal reportRobinson R44 · Homestead, FLThe CFI's inadequate supervision of the student during the instructional flight for his failure to stop an excessive rate of descent which resulted in a hard landing following a reported loss of engine power for undetermined reasons.NTSB LAX05CA104Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Williams, AZthe pilot's improper ground handling procedure and failure to ensure the magnetos were off prior to movement of the propeller.NTSB ANC05LA042Accident · No injuriesLimited investigationFinal reportPiper J-5A · Kenai, AKThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a collision with a snow berm during the landing flare. Factors contributing to the accident were flat light conditions, the presence of a snow berm along the edge of a…NTSB LAX05LA094Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · Cave Creek, AZthe pilot's inadequate handling of the balloon during boarding resulting in a passenger falling and sustaining a serious injury.NTSB SEA05IA040Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Seattle, WAThe flight crew's failure to maintain an adequate visual lookout while on final for a visual approach. Factors include the failure of both airport operations personnel and the local FAA Airports Inspector to insure that some form of identification marking was…NTSB LAX05CA071Accident · No injuriesData collectionFinal reportRobinson R22B · Rialto, CAthe student pilot's improper use of the cyclic control during a practice autorotation, and the inadequate supervision by the certified flight instructor.NTSB DEN05LA048Accident · Minor injuriesLimited investigationFinal reportBoeing 737-724 · Gunnison, COthe snowplow driver's failure to see the airplane during plowing operations. Factors contributing to the accident were the snowplow driver's excessive speed and the snow.NTSB DEN05IA049Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Englewood, COthe flight crew's misidentification of the parallel taxiway as an active runway, resulting in the flight crew executing a landing on the taxiway. Contributing factors include the airport's inadequate snow removal, the snow-covered runway, the visual illusions…NTSB DEN05IA046Incident · Minor injuriesIncident investigationFinal reportBeech 1900D · Denver, COthe tug driver's failure to maintain operational control of the tug, resulting in impact with an airplane. Contributing factors include the tug driver's improper procedure, the tug driver's inadequate initial ground equipment training, and the…