NTSB investigations, 2006
34 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\") = 2006
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") = 2006 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 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.NTSB ANC06LA092Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Deland, FLThe flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…NTSB NYC06LA151Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Dulles, VAThe driver's failure to follow company standard operating procedures. A factor was the driver's diverted attention to an on-time departure.NTSB NYC06CA211Accident · No injuriesData collectionFinal reportErcoupe 415-C · Harrisonburg, VAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with trees.NTSB CHI06CA160Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Gretna, NEA run-on landing encountered by the pilot of the balloon due to the prevailing winds. The unfavorable winds were a contributing factor.NTSB SEA06LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Park Valley, UTIncapacitation of the pilot secondary to a myocardial infarction. A ditch was a contributing factor.NTSB ANC06LA069Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Jacksonville, FLAn undetermined event during takeoff/initial climb, which resulted in an emergency landing after takeoff and substantial damage to the airplane.NTSB NYC06MA131Accident · 1 fatalMajor investigationFinal reportEurocopter EC-135P1 · Washington, DCThe operator's inadequate training program and the pilot's failure to maintain control of the helicopter following his inadvertent disabling of the No. 1 and then the No. 2 engine full authority digital engine control system.NTSB DFW06IA145Incident · 1 fatalIncident investigationFinal reportBell 206L-3 · Grand Isle 43AAThe pilot's incapacitation and death due to pre-existing cardiac disease.NTSB ATL06LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Blacksburg, SCThe pilot's failure to abort the takeoff after the airplane failed to achieve adequate airspeed on the takeoff roll for undetermined reasons. This resulted in an abrupt pull up, inadvertent stall, and in flight collision with wires, trees and the ground.NTSB SEA06IA105Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Portland, ORThe inadvertent deployment of the off-wing escape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel.NTSB NYC06LA115Accident · Serious injuriesLimited investigationFinal reportEmbraer 145LR · Winchester, VAThe passenger's failure to heed the flight attendant warning and the seat belt sign. A factor was the turbulence.NTSB CHI06MA121Accident · No injuriesMajor investigationFinal reportGeneral Atomics Predator B · Nogales, AZThe pilot's failure to use checklist procedures when switching operational control from PPO-1 to PPO-2, which resulted in the fuel valve inadvertently being shut off and the subsequent total loss of engine power, and lack of a flight instructor in the GCS, as…NTSB CHI06CA106Accident · No injuriesData collectionFinal reportWaco EQC-6 · Battle Creek, MIThe maintenance facility failed to properly install and inspect the rudder cable system resulting in the reversed rudder condition which made directional control not possible during the aborted takeoff. A contributing factor was an inadequate preflight…NTSB MIA06LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bunnell, FLThe failure of the pilot to perform a preflight inspection of the airplane resulting in departure with an inadequate oil supply, subsequent engine failure due to oil starvation, and damage to the airplane during a forced landing. Contributing to the accident…NTSB NYC06FA079Accident · 1 fatalField investigationFinal reportBeech 56TC · Winfield, WVThe pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…NTSB CHI06LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Alpena, MIThe station agent's inability to maintain control of the stroller when he lost his balance exiting the airplane's cargo compartment, allowing it to be blown into the operating right propeller. A factor was the high, gusty winds.NTSB DFW06CA064Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawaokecie PZL-104 Wilga 80 · Comstock, TXThe pilot's inadequate preflight planning and preparation leading to him becoming lost. Contributing factors were the unfavorable winds and the lack of suitable terrain for a precautionary landing.NTSB CHI06CA066Accident · No injuriesData collectionFinal reportCessna 120 · Hibbing, MNThe pilot used a rough frozen lake for takeoff which resulted in the overload failure of the landing ski. A factor was the rough frozen lake.