NTSB investigations, 1987
28 cases where the first occurrence was “Fire”.
Cases per year
| 1982 | 27 |
|---|---|
| 1983 | 25 |
| 1984 | 21 |
| 1985 | 30 |
| 1986 | 28 |
| 1987 | 28 |
| 1988 | 15 |
| 1989 | 20 |
| 1990 | 14 |
| 1991 | 16 |
| 1992 | 17 |
| 1993 | 14 |
| 1994 | 22 |
| 1995 | 20 |
| 1996 | 11 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 9 |
| 2000 | 12 |
| 2001 | 17 |
| 2002 | 15 |
| 2003 | 7 |
| 2004 | 12 |
| 2005 | 12 |
| 2006 | 13 |
| 2007 | 17 |
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\") = 1987
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\" = 171)
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") = 1987 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" = 171) 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 NYC88LA058Accident · No injuriesLimited investigationFinal reportCessna 182 · Hammonton, NJThe aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was…NTSB MKC88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osceola, ARThe airplane was being jump-started from an automobile. The flight instructor left for some equipment when the student called him back and said there was smoke in the cabin. The airplane started to burn and was demolished. The student stated there was a…NTSB MKC88IA025Incident · Minor injuriesIncident investigationFinal reportBell 206L-3 · Little Rock, ARAn EMS helo was consumed in a fire while parked at a hospital heliport. The helo had recently returned fm a medevac flt and the on-board patient oxygen pressure was low. Two respiratory therapists participated in refilling the system after the flt. The system…NTSB NYC88FA051Accident · 1 fatalField investigationFinal reportCessna 310R · Hector, NYThe pilot made a routine IFR position report 12 minutes prior to the accident. Witnesses observed an 'orange ball' before the crash. Evidence at the crash site showed inflight jettison of the pilot's emergency window, positive aerodydnamic overload separation…NTSB MIA88LA037Accident · No injuriesLimited investigationFinal reportMandley Steen Skybolt · Placida, FLWhen attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.…NTSB MIA88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ft. Myers, FLAccording to a witness the acft was taxiing slowly but at a higher than normal RPM. When the acft was stopped in the runup area, the right main landing gear caught on fire burning the bottoms of both wings. Examination of the brakes revealed that the linings…NTSB FTW88FA007Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Houston, TXThe acft developed a fire in the eng area during the initial climb after takeoff. When the eng lost power the plt attempted a lndg in a small park. The acft touched down just short of a drainage ditch and collided with the sloping embankment on the opposite…NTSB MIA88IA011Incident · No injuriesIncident investigationFinal reportCASA C-212-200 · Mayaguez, PRThe commuter flt was taxiing to the gate, when the plt observed a fire warning light for the no 2 eng. The fire bottle was discharged & the fire was extinguished. An exam revealed that a fuel line, p/n 3103385-1, had broken and had started a fire. An exam of…NTSB MKC88FA005Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Lincoln, NEDuring climbout, smoke began filling the cabin and shortly thereafter the eng stopped. Ground witnesses observed smoke coming from the eng compartment just before the acft impacted a large woodpile behind a house located 1/2 mile east of the arpt. Examination…NTSB ATL88LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sebring, OHWhile on final appch to land, a fire broke out in the airplane engine compartment. The commercial plt and his instructor evacuated the airplane after ldg and the airplane was destroyed by the fire. The acft was subsequently examined by an IA mechanic who…NTSB ATL88LA006Accident · No injuriesLimited investigationFinal reportBeech H-18 · Sandersville, GAThe cockpit began to fill with smoke during initial climb after the plt raised the ldg gear. The plt returned to the arpt and made an emergency ldg. After evacuating the acft, the plt observed that the rt engine nacelle aft of the firewall was on fire.…NTSB DEN88LA004Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Rio Rancho, NMThe plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket…NTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…NTSB CHI87LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Indianapolis, INThe acft was on the third tkof of the day when the eng stopped on initial climb at the pilots estimated alt of 500 ft. he did a 180 turn back to the arpt but touched down short and ran through the perimeter fence. Examination of the acft revealed that the…NTSB LAX87FA306Accident · No injuriesField investigationFinal reportCessna 421C · Clifton, AZThe flt deptd ry 25 at greenlee cty arpt, Clifton, AZ on a VFR flt to phoenix, AZ. The plt & gnd witnesses rptd that shortly after lift-off, grayish/white smoke emanated from the left engine. The plt was unable to feather the prop, circled the arpt abt 2…NTSB FTW87FA197Accident · No injuriesField investigationFinal reportPiper PA-32R · Mexia, TXThe plt noticed smoke in the cockpit & started to make a precautionary lndg at Mexia, TX, which was nearby. However, drg the dscnt to lnd, the smoke dissipated, so he elected to cont to the destn. Drg the climb back to alt, smoke reappeared & was followed by…NTSB MKC87LA154Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Oelwein, IADuring a personal night x-c flt, the plt noticed a glowing condition in the engine compartment and also a loss of manifold pressure. The plt shut the fuel off, pulled the mixture to cutoff, and declared an emergency. The acft made an emergency landing in a…NTSB MIA87FA205Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Palatka, FLWitnesses stated that they heard the acft's eng sounding rough just before it crashed into the trees. Another witness stated that he noticed that there were flames & smoke coming from the left side of the plane. A tail pipe assembly was found on the ramp at…NTSB MKC87LA133Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mcdougal, ARThe ag airplane was on takeoff roll when the pilot smelled smoke in the cockpit. He stopped the airplane and turned off the fuel and switches before evacuating the airplane. He said the flames were coming from the cowling around the engine. Due to the total…NTSB SEA87IA127Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace BAE-146-100 · Las Vegas, NVDuring pushback and while starting the #4 engine the auxiliary power unit which provides electrical power to the engine starter tripped off the line. The loss of electrical power to the engine starter resulted in a hung start at approximately 25% N2 RPM.…NTSB FTW87FA142Accident · Serious injuriesField investigationFinal reportBeech 35 · Cookson, OKJust after takeoff smoke was smelled and then observed in the cockpit. The pilot beleived that the smoke source was electrical and turned off the master switch. Just before touchdown flames began burning the pilots left leg. The aircraft was stopped on the…NTSB NYC87FA146Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Sayre, PADrg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.…NTSB FTW87FA116Accident · No injuriesField investigationFinal reportBeech V35-B · Terrell, TXWhile attempting to start the aircraft the starter solenoid wiring caught fire. The heat from the fire caused an overstressed brake line to fall, allowing brake fluid to drain onto the lip of the nose gear door. The fire then burned through the floor of the…NTSB LAX87DUM02Accident · No injuriesFinal reportRockwell S2R · Imperial, CADuring an aerial application applying sulphur, the sulphur ignited inflight. The pilot turned the aircraft back toward the airport; however, the cockpit filled with smoke and the pilot decided to land on a road. Due to the extent of fire damage it could not…NTSB LAX87LA192Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Novato, CAThe plt aborted the takeoff attempt before becoming airborne at a point near midfield on the 3360 ft rwy. He rptd smoke in the cockpit from an electrical short of unrptd origin. Both the plt and the plt-rated pax thought they would be able to stop on the…NTSB ATL87LA120Accident · No injuriesLimited investigationFinal reportCessna R182 · Owensboro, KYPlt in cruise flt at 5500 ft about 30 min after dep fm paducah when he noted a small amount of black smoke coming from top of panel. The rear seat pax noted flames in the panel at the same time. The plt noted his position in relation to Owensboro and…NTSB LAX87LA158Accident · No injuriesLimited investigationFinal reportThorp T-18 · Riverside, CAWhile on a flt to practice aerobatics, the plt was flying at 3500' when he felt a cold liquid on his rgt leg & noted the odor of fuel in the cockpit. Moments later, flames erupted in the cockpit. The plt bailed out & the airplane crashed on the southeast…NTSB ATL87MA057Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Pollockville, NCThe emerg med svc (ems/med-evac) helicopter (hel) was on a ngt flt with a 3 month old patient aboard. After rprtg lvl AT3000', the plt transmitted he was going to make an emerg lndg. This was flwd by svrl unreadable transmissions which apchctl psnl thought…