NTSB investigations, 2003, PA
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 2 |
|---|---|
| 1964 | 157 |
| 1965 | 149 |
| 1966 | 172 |
| 1967 | 192 |
| 1968 | 154 |
| 1969 | 132 |
| 1970 | 136 |
| 1971 | 153 |
| 1972 | 104 |
| 1973 | 118 |
| 1974 | 143 |
| 1975 | 131 |
| 1976 | 123 |
| 1977 | 116 |
| 1978 | 124 |
| 1979 | 109 |
| 1980 | 89 |
| 1981 | 92 |
| 1982 | 96 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 75 |
| 1986 | 64 |
| 1987 | 64 |
| 1988 | 65 |
| 1989 | 45 |
| 1990 | 65 |
| 1991 | 47 |
| 1992 | 47 |
| 1993 | 48 |
| 1994 | 41 |
| 1995 | 55 |
| 1996 | 38 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 41 |
| 2000 | 47 |
| 2001 | 34 |
| 2002 | 35 |
| 2003 | 29 |
| 2004 | 37 |
| 2005 | 33 |
| 2006 | 36 |
| 2007 | 35 |
| 2008 | 33 |
| 2009 | 30 |
| 2010 | 19 |
| 2011 | 27 |
| 2012 | 39 |
| 2013 | 27 |
| 2014 | 24 |
| 2015 | 35 |
| 2016 | 32 |
| 2017 | 33 |
| 2018 | 28 |
| 2019 | 30 |
| 2020 | 19 |
| 2021 | 28 |
| 2022 | 35 |
| 2023 | 11 |
| 2024 | 19 |
| 2025 | 17 |
| 2026 | 12 |
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\") = 2003
AND c.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
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") = 2003 AND c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' 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 IAD04LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-44 · Prospect, PAThe flight instructor's improper in-flight decision, which included an inappropriate altitude selection for intentional single engine operation. Factors were the inability of the flight instructor to restart the right engine for undetermined reasons, and the…NTSB IAD04CA004Accident · No injuriesData collectionFinal reportBeech BE-55 · E. Stroudsburg, PAThe pilot's improper flare, which resulted in a hard landing and collapse of the nose landing gear.NTSB NYC04LA045Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot's improper use of carburetor heat, which resulted in a total loss of engine power during cruise flight. A factor was carburetor icing conditions.NTSB NYC04LA044Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Reading, PAThe pilot's improper decision to not apply de-icing fluid to the wings prior to takeoff, which resulted in snow/ice contamination on the of the wings, a stall mush, and a forced landing in an open field.NTSB NYC04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kutztown, PAThe pilot's inadvertent retraction of the landing gear on the ground.NTSB NYC04LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Tunkhannock, PAThe pilot's misjudgment of distance resulting in an overrun.NTSB NYC04LA027Accident · No injuriesLimited investigationFinal reportBeech M35 · Bellefonte, PAA total loss of engine power during approach for undetermined reasons.NTSB NYC03CA209Accident · No injuriesData collectionFinal reportWells Pitts S1S · Duncannon, PAThe pilot's failure to maintain directional control while landing. Factors were the gusting cross winds.NTSB NYC03CA185Accident · Minor injuriesData collectionFinal reportCessna 172E · Lemont Furnace, PAThe pilot's improper bounced landing recovery. A factor was the pilot's inadequate flare during the initial touchdown.NTSB IAD03FA070Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Factoryville, PAThe pilot's improper in-flight decision to descend below the published minimum descent altitude while executing a non-precision approach in instrument meteorological conditions, which resulted in collision with trees. A factor was the fog.NTSB NYC03FA176Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Pleasantville, PAThe pilot's improper IFR procedure by his failure to maintain published altitudes, which resulted in the in-flight collision with terrain. A factor was his impairment due to prescription medication.NTSB NYC03FA164Accident · 1 fatalField investigationFinal reportHawker T Mk 7A · Pittston, PAThe pilot's failure to abort the takeoff, after the engine experienced a partial power loss for undetermined reasons. Factors were the pilot's improper preflight planning by his failure to determine if the airplane was airworthy, and the operators inadequate…NTSB NYC03FA161Accident · 1 fatalField investigationFinal reportCessna T210L · Quakertown, PAA loss of engine power for undetermined reasons.NTSB NYC03CA152Accident · Minor injuriesData collectionFinal reportMaule MX-7-235 · East Brady, PAThe pilot's failure to maintain control of the airplane during landing.NTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.NTSB NYC03LA127Accident · Minor injuriesLimited investigationFinal reportCessna 172H · East Vincent, PAThe pilot's inadequate in-flight planning/preparation which resulted in fuel exhaustion during cruise flight. The pilot's inadequate preflight preparation in which he failed to refuel the airplane is a contributing factor.NTSB NYC03LA115Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman D75-N1 · Avis, PAA loss of engine power due to carburetor ice. A factor in this accident were weather conditions favorable to carburetor ice.NTSB NYC03LA110Accident · No injuriesLimited investigationFinal reportAgusta A109E · Harbor Creek, PAThe pilot's improper preflight inspection, during which he failed to remove a flashlight from the tailboom strake. A factor was the pilot's attention be diverted by a mechanic during the preflight inspection.NTSB NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC03FA088Accident · 2 fatalField investigationFinal reportAviat Pitts S-2B · Newport, PAThe pilot's improper decision to perform aerobatics at a low altitude, which inhibited his ability to recover from an encountered flat spin. A factor related to the accident was the aft center of gravity, which was beyond the operational limit for the…NTSB NYC03LA087Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Waterford, PAThe pilot's inadequate visual lookout which resulted in the collision with the wire. Factors in the accident were the concealment of the poles by trees, the lack of contrast between the wire and grass field.NTSB NYC03LA081Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-30 · Du Bois, PAThe captain's failure to maintain the proper glidepath during the instrument approach, and his failure to perform a go-around. Factors were a low ceiling and reduced visibility due to mist.NTSB NYC03LA077Accident · No injuriesLimited investigationFinal reportWaco YOC · Allentown, PAThe pilot's failure to maintain directional control while landing which resulted in a ground loop. A factor in the accident was the crosswind.NTSB NYC03LA075Accident · Serious injuriesLimited investigationFinal reportBeech B-60 · Bradford, PAThe pilot's improper decision to maneuver for a landing in a configuration that exceeded the capability of the airplane to maintain altitude, after he lost power on one engine for undetermined reason(s).NTSB IAD03LA051Accident · No injuriesLimited investigationFinal reportBell 47G · Lehighton, PAThe student pilot's improper flare, which resulted in a hard landing, and his continued flight operations with a known discrepancy.NTSB IAD03LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Honesdale, PAThe pilot's failure to maintain directional control while landing. A factor was the crosswind.NTSB NYC03LA063Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Zelienople, PAThe failure of the tail rotor assembly due to improper maintenance by the owner/pilot.NTSB NYC03FA058Accident · 1 fatalField investigationFinal reportCessna 182G · Renfrew, PAThe pilot's failure to maintain control of the airplane while maneuvering to land. Factors in the accident were the pilot's decision to fly into forecasted\known icing conditions, and the accumulation of structural ice.NTSB NYC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Blue Bell, PAThe pilot's failure to maintain directional control after a loss of engine power for undetermined reasons.